Contents Index DATE_ORDER option [compatibility] DELAYED_COMMIT_TIMEOUT option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

DEFAULT_TIMESTAMP_INCREMENT option [database]


Function 

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

Allowed values 

Integer, between 1 and 60 000 000 inclusive.

Scope 

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

Default 

1

See also 

TRUNCATE_TIMESTAMP_VALUES option [database]

Description 

Since a TIMESTAMP value is precise to six decimal places in Adaptive Server 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 Adaptive Server Anywhere stores to maintain compatibility.


Contents Index DATE_ORDER option [compatibility] DELAYED_COMMIT_TIMEOUT option [database]