Some Anywhere database options are not supported by IQ, including: DEFAULT_TIMESTAMP_INCREMENT, JAVA_INPUT_OUTPUT.
Some database options only apply 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.
IQ also includes many options that Anywhere does not support. For details, see Chapter 2, “Database Options.”