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
3
votes
1 answer

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified from Window Service

i have created a windows service which needs to connect to Sybase database using ODBC connection in regular intervals and process data. I am getting below error when i am trying to open ODBC connection in windows service class (say "StarterClass")…
user1061732
  • 41
  • 1
  • 1
  • 2
3
votes
2 answers

Using Apache Hadoop in a Cognos BI environment

This might be a dumb question since I have not yet fully understood how Cognos BI works. Also, I tried posting this on Stack Exchange, in vain (error with putting tags). My question is - Can Apache Hadoop be used to make Cognos BI work faster ? Or…
kaustav datta
  • 687
  • 2
  • 11
  • 31
3
votes
1 answer

How to get an object ID from temporary table using object_id function

I have created a table as below: create table #tab ( id int ) Now, I want to get an object id of the table. I tried on the same session: select object_id( "#tab" ) and select object_id( "tempdb..#tab" ) but both return null.
Robert
  • 25,425
  • 8
  • 67
  • 81
2
votes
1 answer

sybase interactive sql initialization error (java path)

Getting this error, from the looks of which it's a missing classpath. Trying to force the classpath via setting it like below doesn't help. set CLASSPATH=C:\Sybase\Shared\SAPJRE-8_1_008_64BIT\lib This is a relatively fresh installation of Sybase…
transfer 2019
  • 21
  • 1
2
votes
3 answers

Sybase IQ connection in Python

I've spent a few days trying to determine how to connect to a Sybase IQ database through Python 3.6. I've tried pyodbc and pymssql, to no avail. Below are two code snippets that I've been working on, which don't seem to work, no matter what I…
xtheking
  • 575
  • 2
  • 8
  • 31
2
votes
4 answers

Sybase BCP - include Column header

Sybase BCP exports nicely but only includes the data. Is there a way to include column names in the output?
dps123
  • 1,033
  • 6
  • 19
  • 26
2
votes
2 answers

Sybase IQ replication

I am using Sybase IQ 15, looking for a mechanism to replicate IQ tables to IQ replication server. How to find if data has changed in IQ ( there are no triggers in IQ) Able to replicate tables having timestamp and id columns.
Nishad
  • 426
  • 2
  • 7
  • 20
2
votes
1 answer

Extracting SAP SQL Anywhere .db/.log database files with free unix tools?

I've recently gotten a copy of a SAP SQL Anywhere 12.0.1.3152[1] .db and .log file. I don't have access to the source database, only these two files. This is an ARGUS database of public records I'd like to make publicly available (via BigQuery).…
Sai
  • 6,919
  • 6
  • 42
  • 54
2
votes
1 answer

Error while executing sqoop eval command

I am executing the sqoop command from home dir. This sqoop command are connecting sybase Sqoop list-tables command is working fine . I am able to see the list of tables sqoop list-tables \ --connect…
Surender Raja
  • 3,553
  • 8
  • 44
  • 80
2
votes
2 answers

Client side to connect to sybase IQ using Python3

I am using Ubuntu and I want to connect to a sybase IQ server (remote) from my client machine ,I tried installing/using sqlanydb according to sybase documentation, but i don't see any parameter in sqlanydb.connect() related to IP of the sybase…
john.doo
  • 23
  • 1
  • 3
2
votes
2 answers

Using LIST and sorting in Sybase IQ - multiple LIST selects throws off "ORDER BY"?

My query does something like... LIST( column1, " ;" ORDER BY column2) This works. When I add more LIST functions in my SELECT then the ORDER BY is ignored. Anyone know why that might be occurring? I'd like to avoid doing unions or running the…
cpd1
  • 777
  • 11
  • 31
2
votes
2 answers

How do you LOAD TABLE in Sybase IQ from a client using Java?

Is it possible to load a file from a client computer into a table in Sybase IQ, using the LOAD TABLE ... USING CLIENT FILE statement? The data does not come from a database, but rather an external source. Can this be done using a JDBC driver in…
Nicolai
  • 3,698
  • 3
  • 30
  • 34
2
votes
2 answers

Calculate with consecutive indicator

So here is the table: Name Indicator Amount Anson 1 3.5 Anson 2 2.6 Anson 3 8.4 Anson 4 3.2 Anson 6 3.7 Ben 1 7 Ben 3 4.7 Ben 4 …
gsql
  • 45
  • 4
2
votes
2 answers

How can i get the total amount with consecutive indicator?

So here is the table: Name Indicator Amount Anson 1 3.5 Anson 2 2.6 Anson 4 8.4 Anson 5 3.2 Ben 1 7 Ben 3 4.7 Ben 4 3.6 How can I get the…
gsql
  • 45
  • 4
2
votes
3 answers

Starting a database connection with sqlanydb inside a fork

Based on an example for forking, I build up this little script: #!/usr/bin/env python # -*- coding: utf-8 -*- import sqlanydb import os def child(): conn = sqlanydb.connect(uid='dba', pwd='sql', eng='somedb_IQ', dbn='somedb') curs =…
frlan
  • 6,950
  • 3
  • 31
  • 72
1
2
3
…
19 20