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.
Questions tagged [sap-iq]
287 questions
0
votes
1 answer
SQL to change user in Sybase IQ
Is there an SQL in Sybase IQ so that I can change the username ? In Sybase ASE you can change database by the 'USE' statement or in PostgreSQL which has SET search_path TO myschema;
Any similar SQL in Sybase IQ ?
tariq
- 615
- 5
- 12
0
votes
1 answer
Sybase-IQ : Query with join returns always 0 rows (but count(*) give rows)
I have a very strange comportment on my Sybase IQ database.
I have 2 tables :
Table A : 47 000 000 rows
Table B : 497 rows
If I make the following query :
select count(*) from A
inner join B on A.ID = B.ID;
The result of the count is 5 661 188.
If…
tangiobs
- 11
- 2
0
votes
2 answers
How does the while loop work?
declare @t INT = 1
declare @i INT = 1
while @t <= 5
BEGIN
while @i <= 40
BEGIN
set @i = @i + 1
END
set @t = @t + 1
select @t
END
The result I get is @t=2. If I replace it with @i I get @i=41. Why does the @variable in the…
theweeknd
- 277
- 1
- 12
0
votes
1 answer
Sybase buffer cache error while retrieving data from table
Hi I am very new to Sybase IQ, I'm inserting data into 309 columns at once. While I was retrieving I am getting the below error.
*Tagged Sybase ASE only in a view that you might have knowledge on IQ as well
Chakri
- 770
- 2
- 7
- 24
0
votes
3 answers
Determine all columns from a table and write them separated by commas in a variable
--Dummy table
create table table1 (
column_order varchar (100)
)
insert into table1 values ('column1')
insert into table1 values ('column2')
insert into table1 values ('column3')
insert into table1 values ('column4')
insert into table1 values…
theweeknd
- 277
- 1
- 12
0
votes
2 answers
Merging two dynamic SQL statements into one
So I made a procedure that makes a dynamic view using dynamic SQL, but I used two sql executions: One for the if clause and one for the else, it should be possible to put it all under one SQL string or am i wrong? Because I tried it and get an error…
theweeknd
- 277
- 1
- 12
0
votes
1 answer
How to find out data type in IQ
I want to make a select statement that shows me all user tables, columns, data types and data length of the selected columns.
I have done it already in ASE but the system tables in IQ are different and I can't join the necessary tables to get my…
theweeknd
- 277
- 1
- 12
0
votes
1 answer
Transaction X attempted to access an object created by transaction Y via JDBC
I have JDBC code which talks to Sybase IQ. One of the thread is loading/update data into one Sybase IQ table say t1. Other threads will try to fire SQL query on table t1 after the first finished loading/updating data.
Write thread:
Create table t1,…
Umesh K
- 13,436
- 25
- 87
- 129
0
votes
2 answers
Sybase IQ: load table with autoincrement column
I need to transfer a table from database A to database B, the table has an autoincrement column. The content of the table in the new database has to be identical to the table in the original database, including the values in the autoincrement…
ps0604
- 1,227
- 23
- 133
- 330
0
votes
2 answers
Length of Bind host variable exceeds MaxLength
I've encountered a cryptic error message thrown by Sybase IQ server.
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -1001019: Function
not supported on varchars longer than 255 Length of Bind host variable
exceeds MaxLength ,
--…
janetsmith
- 8,562
- 11
- 58
- 76
0
votes
0 answers
Error on loading csv to SybaseIQ using dbisql
I am trying to upload a bunch of csv's to SybaseIQ using dbisql's Load command.
My CSV's look like this
"ps,abc","jgh","kyj"
"gh",""jkl","qr,t"
and my Load command and other options are these:
set temporary option ISQL_LOG =…
prats
- 225
- 5
- 15
0
votes
1 answer
ASP.NET MVC Sybase IQ 15
I am attempting to connect to my company's database which is Sybase IQ 15.4.
I am using MVC 5 EF 6, every connection string I find on http://www.connectionstrings.com/
does not work (or at least I have not been able to get it to work)
I thought I…
scripter78
- 1,117
- 3
- 22
- 50
0
votes
1 answer
What is Sybase IQ's query plan?
The main problem is this line
SET TEMPORARY OPTION QUERY_PLAN_AS_HTML_DIRECTORY = ‘#WHAT SHOULD I TYPE HERE?, THERE ARE ONLY DATABASES ON MY LEFT HAND SIDE’;
I don't understand the concept of directories in database.
I've read what the option…
raka
- 355
- 1
- 6
- 14
0
votes
1 answer
CTE Error near Update
Hi I am using Sybase 16.
Whenever I run this CTE, it gives me an error: 'Syntax error near Update'...
With Remove_Dup_Nov13(pk_viewing_prog_instance_fact, Rank_instance)
As
(Select pk_viewing_prog_instance_fact,
row_number()over(partition by…
SouravD
- 127
- 1
- 12
0
votes
0 answers
Load data from Oracle into Sybase IQ
How can I load data from Oracle (11g EE R11.2.0.3.0 64bit) into Sybase IQ (15.4.0.3027 64bit) with acceptable speed?
For Initial data load, data is pushed via Sybase Loader as bulk. This works fine.
But after that, data (eg. new data, changes,…
BaseBallBatBoy
- 685
- 2
- 12
- 25