on 03-27-2015 4:15 PM
Hi Experts/Gurus,
SAP IQ Version : SAP IQ/16.0.0.808/141110/P/sp08.20/Sun_Sparc/OS 5.10/64bit/2014-11-10 16:49:24
Getting below error while trying to execute SELECT sa_get_table_definition( 'GROUPO', 'Departments');
RAISERROR executed: sa_get_table_definition not implemented for IQ
tables
SQLCODE=-30000, ODBC 3 State="HY000"
What is the highlighted line means, while procedure listed in the sysobjects table??
Please help me to understand.
I will be thankful & appreciate your response.
----
Thanks & Regards
Hi,
The sa_get_table_definition procedure is only supported for SQL Anywhere tables.
If run against an SAP Sybase IQ table, the procedure returns the error not implemented for IQ tables.
Please refer to below URL.
SQL Anywhere Supported Procedures
I recommend to use below procedure for IQ.
- sp_iqtable
- sp_iqhelp
....
==
Gi-Sung Jang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The system table are stored in system db (xxx.db) in IQ.
You can find the objects that stored in system area(SQL Anywhere) like below.
-> select * from systable where server_type='SA' ;
- select * from sysfile where dbspace_name = 'system';
And You can store the objects in system area as follows.
Ex) create table test_tb (c1 int) in system.
select sa_get_table_definition('DBA','test_tb'); //You can get the results.
But this area is not user table but system objects in IQ.
IQ consists of two parts "IQ" and "SQL Anywhere".
Please refer to below URL for details.
So I strongly recommend that you don't store any objects in system area.
==
Gi-Sung Jang
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.