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
11
votes
2 answers
Sybase Adaptive Server IQ can't SELECT *, always limited to 30?
I've this problem with a Sybase IQ database (version SELECT @@version shows Adaptive Server IQ/12.5.0/0306) using the PHP SQL Anywhere extension.
I can't select all rows, i.e. SELECT * from anytable always returns 30 rows.
The only workaround I've…
gremo
- 47,186
- 75
- 257
- 421
7
votes
4 answers
Sybase IQ - how to show stored procedure without wrapping text?
Using Sybase IQ v12.7. Executing sp_helptext ProcedureName shows the text of the stored procedure which is fine. However it wraps lines at 80 characters. The question is, how to show text text of a stored procedure without wrapping?
In Sybase…
FuzzyWuzzy
- 763
- 1
- 6
- 12
7
votes
3 answers
list all tables from a database in syBase
In sql server 2012 i'm using
USE myDatabase;
GO
SELECT *
FROM sys.objects
WHERE type = 'U';
Is it possible to do the same in syBase ?
CM2K
- 833
- 3
- 18
- 38
6
votes
10 answers
Are these tables too big for SQL Server or Oracle
I'm not much of a database guru so I would like some advice.
Background
We have 4 tables that are currently stored in Sybase IQ. We don't currently have any choice over this, we're basically stuck with what someone else decided for us. Sybase IQ…
Jeffrey Cameron
- 9,975
- 10
- 45
- 77
4
votes
6 answers
SQL conditional grouping and summing
My data looks like this:
|cat |subcat |amount|
---------------------
|A |1 |123 |
|A |2 |456 |
|B |1 |222 |
|B |2 |333 |
In the first case, I need to sum by cat and subcat. Easy:
SELECT cat, subcat, sum(amount)…
Robert Brown
- 10,888
- 7
- 34
- 40
4
votes
1 answer
Sybase IQ Load Table using client file is failing
I am using Sybase IQ 15 version database.
trying to load IQ table from delimited flat file
Load Table test (a,b)
using client file '/xyz/test.dat'
ESCAPES OFF
FORMAT BCP
DELIMITED BY '|';
is it failing with below error
Msg 21, Level 14, State 0:SQL…
Nishad
- 426
- 2
- 7
- 20
4
votes
1 answer
Update join vs Update with sub query
I have 2 tables :
Table A
ID int,
Name varchar,
Address varchar
Table B
ID int,
Name varchar,
Address varchar,
Col1...
...
Col100
I want to update A.Name with B.Name based on both table's ID.
UPDATE A
SET A.NAME = B.NAME
FROM A JOIN…
EagerToLearn
- 675
- 7
- 24
4
votes
2 answers
How I can Export ddl of all objects like table, index etc in SYBASE IQ/ SYBASE ASE without using any tools?
I have created a sample program in which I want to get ddl of all objects like table, trigger etc using get_ddl method. When I tried following queries in oracle it worked.
SELECT DBMS_METADATA.GET_DDL('TABLE', TABLE_NAME) FROM USER_TABLES;
SELECT…
santosh
- 435
- 1
- 7
- 24
3
votes
3 answers
Selecting a Random Subset in SQL (Sybase Server IQ)
I'm trying to select a random subset of records using either rand() or newid(), but any time I run the following, I always get the same results back:
SELECT *,rand() as rid
INTO #mytable
FROM othertable
select top 10 * from #mytable order by…
user1167650
- 3,177
- 11
- 34
- 46
3
votes
2 answers
T-SQL what does " is not accessible in this context" mean? (SQL Code: 1001042)
Using Sybase IQ 12.5,
When I try to insert the result of a stored proc into a table like this:
INSERT mytable (column1, column2, column3)
SELECT column1, column2, column3
FROM (myproc('AAA'))
I get the following:
ASA Error -1001042: Table,…
Robert Brown
- 10,888
- 7
- 34
- 40
3
votes
4 answers
is there any faster way to populate a resultset from a database query?
i have the following code that queries a db and populates a datatable.
private DataTable Run(string sql)
{
var conn = new OdbcConnection();
string connString = "[myConnString];";
conn.ConnectionString = connString;
…
leora
- 188,729
- 360
- 878
- 1,366
3
votes
3 answers
PreparedStatement Does Not Work For Sybase IQ In Java
Me and my team faced a problem. We are trying to retrieve some data from Sybase IQ database and are using where clause to filter out and get specific data.
The SQL is tested and works fine but it fails when using Prepared Statement.
Tests done:
If…
Mantas
- 33
- 7
3
votes
1 answer
#temp_table vs user.#temp_table sybase_iq
i wonder what is the difference between #temp_table and user.#temp_table
-- 1) #Tem_table
create table #temp_table
( id integer null);
select * from #temp_table -- find
select * from sysobjects where name = '#temp_table'-- not found
--…
MarKuz
- 53
- 8
3
votes
1 answer
How to get the table name that is related to specific schema in sybase IQ
My requirement is to use syscolumn and systable system tables. By using these 2 tables, return the specific table within specific schema. But systable is holding same table name from 3 different schemas, how to get the table name with requried…
Naveen Reddy CH
- 799
- 2
- 13
- 23
3
votes
2 answers
PHP Insert into database without waiting database response
I have to insert some values to database from my php code. But the time of script execution is very expensive so I should finish my script as fast as possible. So I just need to 'say' my script to insert values to database and I don't care how many…
Daria
- 861
- 11
- 29