SQL Anywhere and Sybase IQ Differences and Shared Functionality

Sybase IQ and SQL Anywhere have differences in starting and managing databases and servers, database option support, DDL support, and DML support.

For additional information, always refer to the Sybase IQ documentation set when using the product. Refer to the SQL Anywhere documentation set when using SQL Anywhere, or when the Sybase IQ documentation refers to SQL Anywhere documentation for specific functionality only.

• SQL Anywhere Server and Database Startup and Administration
  Starting and managing databases and servers differs between Sybase IQ and SQL Anywhere.
• SQL Anywhere Database Options
  Some SQL Anywhere database options are not supported by Sybase IQ, including DEFAULT_TIMESTAMP_INCREMENT.
• SQL Anywhere Data Definition Language (DDL) Differences
  In addition to the DDL differences discussed previously:
• SQL Anywhere Data Manipulation Language (DML) Differences
  Not all SQL Anywhere DML objects and syntax are supported by Sybase IQ.