Database options

Some SQL Anywhere database options are not supported by Sybase IQ, including DEFAULT_TIMESTAMP_INCREMENT.

Some database options apply only to the catalog store, including: FOR_XML_NULL_TREATMENT, ISOLATION_LEVEL, PREFETCH, PRECISION, and SCALE.

Options with differences in behavior, default, or allowed values include DELAYED_COMMITS, TIME_FORMAT, TIMESTAMP_FORMAT.

Sybase IQ also includes many options that SQL Anywhere does not support. See Chapter 2, “Database Options.” in Reference: Statements and Options.