Some Adaptive Server Anywhere database options are not supported by Sybase IQ, including: DEFAULT_TIMESTAMP_INCREMENT and JAVA_INPUT_OUTPUT.
Some database options apply only to the Catalog Store, including: FOR_XML_NULL_TREATMENT, ISOLATION_LEVEL, PREFETCH, PRECISION, SCALE, and TRUNCATE_WITH_AUTO_COMMIT.
Options with differences in behavior, default, or allowed values include DELAYED_COMMITS, JAVA_HEAP_SIZE, TIME_FORMAT, TIMESTAMP_FORMAT.
Sybase IQ also includes many options that Adaptive Server Anywhere does not support. For details, see Chapter 2, “Database Options.”
