Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

default_dbspace option [database] Next Page

default_timestamp_increment option [database] [MobiLink client]

Specifies the number of microseconds to add to a column of type TIMESTAMP to keep values in the column unique.

Allowed values

Integer, between 1 and 1000000 inclusive




Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.


Since a TIMESTAMP value is precise to six decimal places in SQL Anywhere, by default 1 microsecond (0.000001 of a second) is added to differentiate between two identical TIMESTAMP values.

Some software, such as Microsoft Access, truncates TIMESTAMP values to three decimal places, making valid comparisons a problem. You can set the truncate_timestamp_values option to On to specify the number of decimal place values SQL Anywhere stores to maintain compatibility.

For MobiLink synchronization, if you are going to set this option, it must be set prior to performing the first synchronization.

See also