cancel
Showing results for 
Search instead for 
Did you mean: 

sa_get_table_definition

SybDBA
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Gisung
Advisor
Advisor
0 Kudos

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

SybDBA
Participant
0 Kudos

Hi Gi-Sung,


Thanks for your prompt response.


What are the SQL Anywhere tables exist in the SAP Sybase IQ 16, and how to get list of those tables ??


-----

Regards


Gisung
Advisor
Advisor
0 Kudos

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.

SQL Anywhere and Sybase IQ

So I strongly recommend that you don't store any objects in system area.

==

Gi-Sung Jang

SybDBA
Participant
0 Kudos

Hi Gi-Sung,

Good description of the topic.

Thankful to you and appreciating your response.

---

Regards

Gisung
Advisor
Advisor
0 Kudos

I'm glad to help you.

==

Gi-Sung JAng

Answers (0)