SQL Anywhere Data Manipulation Language (DML) Differences

Not all SQL Anywhere DML objects and syntax are supported by SAP Sybase IQ.

SAP 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
Note: A set of extraction options perform a role similar to UNLOAD TABLE.
SAP Sybase IQ supports the INSERT...LOCATION syntax; SQL Anywhere does not.
LOAD TABLE options differ in SAP Sybase IQ and SQL Anywhere.
OPEN statement in SAP Sybase IQ does not support BLOCK and ISOLATION LEVEL clauses.
SAP Sybase IQ does not support triggers.
Use of transactions, isolation levels, checkpoints, and automatically generated COMMITs, as well as cursor support, is different in SAP Sybase IQ and SQL Anywhere.
When you SELECT from a stored procedure in SAP Sybase IQ, CIS functional compensation performance considerations apply.
SAP 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, SAP Sybase IQ interprets the query SELECT * FROM XXX..TEST as SELECT * FROM TEST.