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
0
votes
3 answers

SQL - ALL, Including all values

I have two tables: create table xyz (campaign_id varchar(10) ,account_number varchar) Insert into xyz values ( 'A', '1'), ('A', '5'), ('A', '7'), ('A', '9'), ('A', '10'), ( 'B', '2'), ('B', '3'), ( 'C', '1'), ('C', '2'), ('C', '3'),…
SouravD
  • 127
  • 1
  • 12
0
votes
2 answers

want to convert string mm/dd/yy to date yyyy/mm/dd format in Sybase

I want to convert date which is string and like mm/dd/yy to date datatype in format yyyy/mm/dd.
RDP
  • 81
  • 2
  • 13
0
votes
2 answers

What is the location of Update and Delete constraint values in Sybase IQ?

In MS SQL @DB_Name.sys.foreign_keys keeps this values in (update|delete)_referential_action columns. Where can I find them in Sybase IQ? Do values equal to MS SQL indexes/values? Thank you. MS: 0 = No action 1 = Cascade 2 = Set null 3 = Set…
Andrii Horda
  • 170
  • 1
  • 16
0
votes
1 answer

Spring Batch using Sybase IQ data source

How do we properly configure Sybase datasource in a Spring Batch? Currently I am using a JdbcPagingItemReader for reading DB and creating the data source using Tomcat DBCP. However the following error occurs on the batch run. Caused by:…
ram
  • 747
  • 2
  • 11
  • 34
0
votes
2 answers

Sybase IQ, return the result of a query string in a variable inside a function with "execute"?

Hi can you help me please?, That way I can return the result of a query string in a variable inside a function with "execute"?. for example create function my _funcion(in @ num_celular char (20), in @ str_comando char (120)) returns char (120) - on…
user2932523
  • 1
  • 1
  • 2
0
votes
1 answer

Display Sybase IQ timestamp column for specific timezone

I have columns in Sybase IQ with data type as "timestamp". I wonder how do I make the timestamp type columns to show for different timezones when doing queries, i.e. in Aqua Data Studio? Or how do I know what is the timezone I am getting from the…
sxy
  • 187
  • 1
  • 3
  • 10
0
votes
2 answers

how to resolve 'Update operation attempted on non-updatable query'?

I am working on a sybase-iq server Sybase IQ/15.4.0.3014 I have a working query to update one field of a table as below update table1 set a.field1= b.some_value from table1 a, table2 b where a.id = b.id This is working fine when I…
mtk
  • 13,221
  • 16
  • 72
  • 112
0
votes
1 answer

Get all IDENTITY columns in Sybase IQ

I want a list of all identity columns. Do you know in which system table the information can be found? BTW: I use Sybase IQ 16
Tobias Müller
  • 1
  • 2
0
votes
1 answer

While loop or dynamic execution

I have a table: VIEWING_17to31_aug_server which has 393085432 rows. I was trying to update a field by a join condition (the join condition is correct). But the query could not be executed as it exceeded query temp space. I then tried to use while…
SouravD
  • 127
  • 1
  • 12
0
votes
1 answer

connect to a sysbase IQ database using fluent nhibernate

I'm trying to connect to a Sybase IQ Database using Fluent NHibernate (or NHibernate directly if necessary) but I can't seem to find any examples or other input on what driver, dialect and connection string to use. Any help would be…
Cornelius
  • 640
  • 8
  • 22
0
votes
2 answers

how to modify a column's datatype in sybaseIQ

Does anyone know how to modify a column's datatype in sybaseIQ? ie i have table: "MY_TABLE" with col STATUS varchar(100) i want to change it to varchar(10) alter table "MY_TABLE" modify "STATUS" varchar(10) I have tried, the above, but it…
Jackson Ha
  • 662
  • 2
  • 7
  • 13
0
votes
1 answer

connect to Sybase IQ with NHibernate

I want to connect to a Sybase IQ database, which is lying on a server via Fluent NHibernate: I use C# with the NHibernate version 3.3.1.4 I am using the code from…
Higune
  • 643
  • 3
  • 13
  • 31
0
votes
2 answers

PreparedStatement.addBatch and thousands of rows from a file and a confusion

Hi I am trying to write to Sybase IQ using JDBC from a file which contains thousands of rows. People say that I should use batchUpdate. So I am reading file by NIO and adding it to PreparedStatement batches. But I dont see any advantage here for all…
Umesh K
  • 13,436
  • 25
  • 87
  • 129
0
votes
1 answer

How to execute SybaseIQ Load Command in Java

I am developing an application in Java. I have to execute Sybase bulk LOAD command through my code. I am doing it like this: Connection conn = DriverManager.getConnection(); Statement st = conn.createStatement(); Boolean result =…
Neo
  • 93
  • 1
  • 12
0
votes
1 answer

SQL Script to pull duplicate data

Need help pointing in right direction using an SQL query to extract data out of this SYBASE database example: 12345 blue 12345 red 12345 green 56789 purple 56789 black 98765 brown output must look like this: 12345 blue red green 56789 purple…
Harold Elliott
  • 1
1 2 3
…
19 20