Stack Overflow
Stack Overflow

Questions tagged [sap-iq]

SAP IQ (formerly Sybase IQ) is a column-based RDBMS used for business intelligence, data warehousing, and data marts. Produced by Sybase, an SAP company, its primary function is to analyze large amounts of data in a low-cost, high-availability environment.

287 questions
1
vote
1 answer

Error when trying to use ODBC Named Parameter with SAP IQ/Sybase IQ DB

I have the following command that works on mySQL but not working with SAP IQ/Sybase IQ DB: string sql = "select * from someTable where fieldName=@name"; command.CommandText = sql; command.Parameters.Add(new OdbcParameter() { DbType =…
Dor Cohen
  • 16,769
  • 23
  • 93
  • 161
1
vote
0 answers

Overlapping dates specifically within 10 day period of each date

I am trying to find overlapping dates within 10-days of the FROM_DATE for the same PERSON_ID but that occurred under a different MANAGER_ID OR SHIFT_ID. This is missing a number of dates which would show because they all fall 10-days before an…
user5781594
1
vote
1 answer

update statement based end date of previous row equaling start date of next row

I have identified overlapping dates from trainers that trained users between a start date and end date. I now need to identify those USER_IDs where the end date for one of their trainers is the same as the start date for their next trainer. I need…
user5781594
1
vote
1 answer

Sybase LOAD TABLE USING CLIENT FILE failed in java code, using jconn3.jar

When using jconn3.jar to connect to Sybase IQ database, and execute LOAD TABLE ...CLIENT FILE statement in Statement.execute(...) method. Got error: SQL Anywhere Error -1006140: I/O Error on file c:/aa But in Sybase's Interactive SQL client, this…
whunmr
  • 2,435
  • 2
  • 22
  • 35
1
vote
3 answers

Why is this Sybase IQ Update Statment So Slow?

I have one table (Table1) with some info and a string ID I have another table (Table2) with some more info and a similar string ID (it is missing an extra char in the middle). I was originally joining the tables on t2.StringID =…
skimania
  • 917
  • 1
  • 9
  • 20
1
vote
4 answers

using case clause with join statement sql

I have the following query: select * from isg.tdbFutures f, isg.tdbOption e where f.contract = 306121 and e.underlier = f.entityID Which will return this: entityID lastTradeDate expiration firstTradeDate …
Évariste Galois
  • 1,043
  • 2
  • 13
  • 27
1
vote
2 answers

Connect python to Sybase IQ

First of all thank you for your help. I was trying to retrieve some data from a sybase IQ database using python, but I can not make it. I've tried with the following code( from https://github.com/sqlanywhere/sqlanydb): import sqlanydb conn =…
Jessica
  • 11
  • 3
1
vote
1 answer

Why SAP IQ load table option is faster than import wizard in the Interactive SQL?

I did CSV file import using SAP IQ LOAD TABLE SQL command which did it in less than a second, but with Interactive SQL import wizard tool it took almost 2+ hours. I am interested to know why it was so much faster. Table has more than 138'000…
The rhino man
  • 23
  • 4
1
vote
1 answer

SYBASE Table space information

Can any one help me finding the information of multiple tables in SYBASE. I Know in ORACLE we do Select * from USEr_segments;
SUNITH
  • 15
  • 10
1
vote
0 answers

Source Assistant does not recognize SQL Anywhere OLE DB Provider

(I've Googled for hours and searched StackOverflow before posting...) I can create an OLE DB connection to Sybase IQ using the SQL Anywhere OLE DB Provider 11 installed on my machine. So clearly SSDT knows that the driver is there. And the…
Scott
  • 169
  • 1
  • 3
  • 14
1
vote
2 answers

Hibernate + Sybase Iq

I have completed my hibernate project on sql server and now we have to shift from sql server to sybase iq. I have all my queries written in hql and no logic in sql server. Does hibernate supports Sybase Iq? So that i do not have to change anything…
Satyam Prateek
  • 11
  • 2
1
vote
2 answers

SQL Anywhere 17 libdbcapi.so not found

I'm having trouble connecting to a SybaseIQ with PHP A bit of info about the environment : OS : Debian 8.10 Jessie Web hosting plateform : Plesk PHP : 7.1.8 SQL Anywhere php extension : php-7.1.0_sqlanywhere.so SQL Anywhere client : version…
Yex777
  • 57
  • 1
  • 7
1
vote
0 answers

How to rename a VIEW in Sybase IQ

I'm using IQ version 15.4. sp_iqrename works for all object types except views. ALTER VIEW RENAME statement also doesn't work. Is renaming views allowed in IQ? How to do this ?
Subhendu
  • 41
  • 6
1
vote
1 answer

Sybase is sustituting some specials characters for "\1xA"

I have a problem between two enviroments in Sybase IQ The procedure in pre-production enviroment the specials characters are correct inserted and they look like this (ä) case when MyColum = "Something schäft" then X In produccion nerverless…
Enrique Benito Casado
  • 1,914
  • 1
  • 20
  • 40
1
vote
1 answer

5702 : The SQL Server is terminating this process because the database view

after modifying the view as below, if use the view in the select statements by the application(as below query), then we are getting DB error 5702: The SQL Server is terminating this process. Here's the query select * from view1 v1, view2 v2 where…
prabhu kumar SV
  • 11
  • 2
1 2 3
…
19 20