IQ does not support these DML and procedural statements: EXPLAIN, GET DATA, INPUT, OUTPUT, 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 Sybase IQ System Administration Guide.
IQ supports the INSERT...LOCATION syntax; Anywhere does not.
LOAD TABLE options differ in IQ and Anywhere.
OPEN statement in IQ does not support BLOCK and ISOLATION LEVEL clauses.
IQ does not support triggers.
Use of transactions, isolation levels, checkpoints, and automatically generated COMMITs, as well as cursor support, is different in IQ and Anywhere. For details, see Chapter 10, “Transactions and Versioning” in the Sybase IQ System Administration Guide.
When you SELECT from a stored procedure in IQ, CIS functional compensation performance considerations apply. For more information, see “Conditions that cause processing by Adaptive Server Anywhere” in Sybase IQ Performance and Tuning Guide.
