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
2
votes
2 answers

Error using Sybase IQ proxy table

I have a use case that requires me to make a join on a table t1 from Sybase ASE and table t2 from Sybase IQ . I am trying to achieve this by creating a proxy_table on Sybase IQ as follows: create server SYB1 class 'ASAODBC' using …
birjoossh
  • 83
  • 1
  • 8
2
votes
2 answers

Multiple joins to get the same lookup column for different values

We have a rather large SQL query, which is rather poorly performing. One of the problems (from analysing query plan) is the number of joins we have. Essentially we have values in our data that we need to do a look up on another table.to get the…
Dace
  • 489
  • 1
  • 7
  • 17
2
votes
1 answer

Failed to load native dll (C:\Users\[Username]\AppData\Local\Temp\...\dbdata.dll

I'm trying to create an SAConnection into a Sybase IQ database. I'm attempting to create the connection through a simple visual studio C# application. My code fails at: SAConnection connection = new SAConnection(connString); And pops up with a…
Danzomida
  • 475
  • 2
  • 5
  • 11
2
votes
1 answer

Insert ignore alternative for sybase IQ

What is the alternative for Insert ignore in sybase IQ. I want inserts to go through without failing in case of duplicates , and insert all the non-duplicates. The table has a unique key constraint on a column
Raks
  • 870
  • 3
  • 11
  • 27
2
votes
2 answers

how do I query Sybase IQ server using odbc?

How can I query Sybase IQ server from a script such as Python or Perl using ODBC? I searched on internet but I couldn't find a sample connection string. Could someone provide a sample connection string for this? the details i have for connection…
Alok
  • 3,160
  • 3
  • 28
  • 47
1
vote
2 answers

How to find the size of a row in a table in databse(Sybase)

I wanted to know the command to find the size of a row in a table in my database. Say I've a database db and a table table. How can i find the size of a row in that database (which includes all the columns)?
Invictus
  • 4,028
  • 10
  • 50
  • 80
1
vote
1 answer

How to have different calender dates as business month in SQL

account createddate closed_date account_type Debit_Amount txn_date 1234 01/02/2023 01/01/2099 Normal 100 01/02/2023 7892 02/02/2023 01/01/2099 Premimum 200 01/02/2023 4567 03/02/2023 …
scoder
  • 2,451
  • 4
  • 30
  • 70
1
vote
1 answer

Sybase IQ: Converting a string to NUMERIC without error/exception

I'm using Sybase IQ and need to convert a field from string to NUMERIC. The field sometimes has characters other than digits. In those cases I want it to return 0 instead of raising exceptions. How to do so? You may look at the statements below to…
Viet
  • 17,944
  • 33
  • 103
  • 135
1
vote
1 answer

List ODBC DSN Configurations in a Text File

When my machine is reimaged or swapped out, I have to take a screenshot of each Data Source in my the Microsoft ODBC Administration tool to make sure I get it right on the new machine. Even going to a coworker's machine, using their settings might…
undrline - Reinstate Monica
  • 526
  • 1
  • 7
  • 18
1
vote
2 answers

How to UPSERT a record in SAP ASE Sybase 16?

I am literaly following the SAP documentation 1st example on UPSERT a record in ASE: https://help.sap.com/viewer/cbed2190ee2d4486b0bbe0e75bf4b636/16.0.3.2/en-US/faf583d9adc547ad8a164bb3f41ea6cd.html 1> select @@version 2> go Adaptive Server…
João Pereira
  • 13
  • 2
1
vote
0 answers

How to handle TZ names in Sybase IQ 16

In the context of a file ETL process (plain shell + BCP to temporary table + import to final table stored procedure), have a new complication with a import of data from a remote Oracle Database into a Sybase IQ 16 Database. Data to import has a…
João
  • 2,296
  • 5
  • 20
  • 30
1
vote
1 answer

Sybase IQ slow with JOINs?

I keep hearing Sybase IQ works very badly with joins and in my current job main data model (Sybase IQ DB) is View-based with huge denormalized table underneath and still lots of hardcoded logic and number of joins and subqueries (going to 5 levels…
marcinsow
  • 11
  • 2
1
vote
1 answer

Count of rows matching string in Sybase

I have a table that contains three columns, the first is member_id, the second is an index of months and the third is a categorical variable with three distinct values. My data looks as follows: member_id refill_month MEMBER_TYPE 454723 …
TheGoat
  • 2,587
  • 3
  • 25
  • 58
1
vote
1 answer

SQL: convert string to datetime in Sybase IQ

I am trying to convert a string into a datetime in Sybase IQ. The string has this form: '20191211 11:49:00.565224 +0700' I first try with Convert DATETIME: the following 2 queries fail: SELECT CONVERT("DATETIME", '20191211 16:29:56.226560 +0000',…
Courvoisier
  • 904
  • 12
  • 26
1
vote
1 answer

Importing data from Sybase IQ using Sqoop: Syntax error near 'Committed' on line 1

I am trying to import a table from Sybase IQ to a Hive table using the following sqoop command: sqoop import \ --verbose \ --connect jdbc:sybase:Tds:server:port#?ServiceName=dbName \ --username username \ -P \ --driver…
TheGoat
  • 2,587
  • 3
  • 25
  • 58
1 2
3
…
19 20