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
Does Sybase IQ 12.7 subquery using ON perform slower than join?
I have a query in Sybase IQ 12.7 that looks like:
select ip from iplookup where ip in (select ip from persisted_info)
where iplookup is defined as a single column.
I saw the IN and subquery and decided that must be slow (full table scan) and that…
Spaceghost
- 6,835
- 3
- 28
- 42
0
votes
1 answer
How to use Universal Connection Pool (UCP) with Sybase?
Trying to configure connection pooling in standalone Java application.
Using UCP and Sybase DB. I am stuck at Connection Factory ClassName to use for Sybase.
Tried using com.sybase.jdbc4.jdbc.SybConnectionPoolDataSource but with no success.
YoK
- 14,329
- 4
- 49
- 67
0
votes
0 answers
Sybase IQ: Granting a right on tables of one user to anther user
I'm looking for a way to grant some right (say SELECT) on all tables of one user to some other user.
Something like that:
GRANT SELECT ON Username1.* to Username2
Important condition is that I need not only granting the right to all existing…
ipbd
- 524
- 3
- 16
0
votes
1 answer
Was a table created with iq unique option?
I have some tables on sybase-iq data base, created for example:
create table tab
(
id int not null IQ Unique (10)
)
How can I check if table tab was created with iq unique option?
Robert
- 25,425
- 8
- 67
- 81
-1
votes
1 answer
Sybase IQ - Float to Numeric/Decimal conversion changes the scale of the output
I have a follow up question with regards to a similar issue I'm having, as the one posted on this thread: Why when converting SQL Real to Numeric does the scale slightly increase?.
I'm using Sybase IQ 16. I have a column called - StrikePrice with…
Raul
- 1
- 3
-1
votes
1 answer
How to get unique pairs in SQL when there is many to many relationship in data
I have following data. I need to make unique pairs.
element1 element2
E1 C1
E1 C2
E2 C1
E2 C2
E3 C1
E3 C2
How can I use SQL to get pairs as follows:
E1,C1 …
user3376169
- 405
- 1
- 5
- 17
-1
votes
1 answer
Syncing with Amazon Redshift
We have 20TB data on Sybase IQ. It is our primary server. However, it cannot support multiple applications which does intensive querying.
In order to support above requirement, we are planning to port data to Amazon Redshift which will be used for…
user3376169
- 405
- 1
- 5
- 17
-1
votes
2 answers
Changing datetime to date data type with date format?
SELECT CAST(CONVERT(varchar, dateissued, 105) AS date) FROM table1;
The above SQL statement returns null values instead of expected values.
I cannot spot the error.
-1
votes
1 answer
SQL - count without group by? I need to use two ids for a join
I thought I could count a column and add it as a column as I can with a sum but I get an error about having to group by / having. An example of what I want...
Initial table...
Global ID Local ID Name Role
100 1 Andy …
cpd1
- 777
- 11
- 31
-1
votes
1 answer
How to make SybaseIQ case insensitive?
I created my DB(SYbaseIQ 16.X) with Case IGNORE feature, but it's failing for all select due to case sensitivity. I tried ALTER DATABASE command, but it doesn't have any such option.
How can I revert my DB to case IGNORE setting, and also to check…
-1
votes
2 answers
Query to get database log file size
I need the queries for all databases e.g. SQL, Oracle, MySql, etc to get the log file size like for SQl server.
SELECT * FROM sys.database_files
Can anyone help me to find queries for all the databases?
Anand Jagtap
- 41
- 9
-2
votes
1 answer
Regexp in a matching column sql
I have 2 tables. One of them having one of the columns as regexp's. I want to join the two tables on the regexp column. Cannot seem to be able to do this.
To elaborate: table 1 is (errortype, action, error message) and table 2 is(regexp for error…
Snehal Jadhav
- 1
- 1
-2
votes
1 answer
SQL query to get each EID's & JOINING_DT corresponding records in tab2 which are just previous, equal date and all greater date rows from tab2
tab1:
EID JOINING_DT
---------
1 04/04/2018
2 06/06/2018
3 04/04/2018
4 03/03/2018
tab2:
EID JOINING_DT INFO
-------------------
1 01/01/2018 x
1 02/02/2018 x
1 03/03/2018 x
1 04/04/2018 x
1 05/05/2018 x
2 …
MKumar
- 79
- 2
- 6
-2
votes
1 answer
Error:table exists in the database
why is it that using exec() in SYBASE ASE while dropping a table if it exists eliminates the Error:Table exists in the database. Why this error doesn't appear in Sybase IQ.
bned
- 11
- 6
-2
votes
2 answers
Case statement with datedfif and between
I am using Sybase IQ, and have the following SQL code which doesn't seem to work. The issue is with the case statement.. Thanks in advance
SELECT a.cusid, start_date, effective_dt,
case when DATEDIFF(DAY, start_date, effective_dt) >= 5476 THEN…
Nick Edwards
- 55
- 1
- 10