Is there any document about difference on the sql lanugage between ASIQ and ASE?

[Former Member]

Dear all,

   I'm new to ASIQ, Would you please share some documents on the sql language for ASIQ? I find most ASE sql can be used in ASIQ, are they totally compatible?

   Thanks

Regards

Eisen

[tayeb_hadjou · Accepted solution]

Hi Eisen,

Any document referring to SAP Sql Anywhere is also valid. This is because native IQ SQL, known as Watcom, is same as SAP Sql Anywhere. Moreover, IQ uses Sql Anywhere engine parser.

Transact SQL is compatible with IQ, however some rules have to be respected.

One of major rules is: in same Store Procedure, function, batch or compound (one block) sql code, NOT mix both languages.

Also, if a script is origin from ASE, then you often need use Transact SQL compatible options.

Example in ASE, by default Quoted_Identifier are off, Chained off.

When a connection to IQ, uses Open Client (like isql) or jdbc, then the Transqct Sql compatibe options are automatically set.

Related Links

1-Transact-SQL Option Settings for Adaptive Server Compatibility

2- Automatic Translation of Stored Procedures

3-

4- Migrating SQL Anywhere database applications to ASE - SAP SQL Anywhere - SCN Wiki

Regards,

Tayeb.

[Former Member · Accepted solution]

Thank you very much

Regards

Eisen

[john_currie]

You can also see the section "Compatibility with other SAP Database Products" in the SAP IQ Reference: Building Blocks guide:

http://help.sap.com/saphelp_iq1611_iqrefbb/helpdata/en/a5/d9e97d84f210158efdd7e4092eac36/content.htm...