Sybase IQ does not support these DML and procedural statements: EXPLAIN, GET DATA, INPUT, PREPARE TO COMMIT, PUT, READTEXT, ROLLBACK TRIGGER, SYSTEM, UNLOAD TABLE, VALIDATE TABLE.
A set of extraction options perform a role similar to UNLOAD TABLE;
for details, see the section “Data
extraction options” in Chapter
7, “Moving Data In and Out of Databases” in
the System Administration Guide: Volume 1.
Sybase IQ supports the INSERT...LOCATION syntax; SQL Anywhere does not.
LOAD TABLE options differ in Sybase IQ and SQL Anywhere.
OPEN statement in Sybase IQ does not support BLOCK and ISOLATION LEVEL clauses.
Sybase IQ does not support triggers.
Use of transactions, isolation levels, checkpoints, and automatically generated COMMITs, as well as cursor support, is different in Sybase IQ and SQL Anywhere. See Chapter 10, “Transactions and Versioning” in the System Administration Guide: Volume 1.
When you SELECT from a stored procedure in Sybase IQ, CIS functional compensation performance considerations apply. See “Conditions that cause processing by SQL Anywhere” in Performance and Tuning Guide.
Sybase IQ ignores the database name qualifier in
fully qualified names in Adaptive Server Enterprise SELECT statements,
such as a FROM clause with <database
name>.<owner>.<table name>. For
example, Sybase IQ interprets the query SELECT * FROM XXX..TEST as SELECT * FROM
TEST.
