Limits the resolution of timestamp values. As timestamps are inserted into the database, UltraLite truncates them to match this increment.

Syntax

{ ulcreate | ulinit | ulload } -o timestamp_increment=value;...

Allowed values

1 to 60000000 microseconds

Default

1 microsecond

Remarks

1000000 microseconds equals 1 second.

You cannot change the timestamp increment of an existing database. Instead, you must create a new database.

This increment is useful when a DEFAULT TIMESTAMP column is being used as a primary key or row identifier.

From Sybase Central, you can set the timestamp increment in any wizard that creates a database. On the New Database Options page, select the Timestamp Increment option.

From a client application, set this parameter as one of the creation parameters for the create database method on the database manager class.

See also

• UltraLite timestamp_format creation parameter
• UltraLite Create Database utility (ulcreate)
• UltraLite Initialize Database utility (ulinit)
• UltraLite Load XML to Database utility (ulload)
• UltraLite for embedded SQL: ULCreateDatabase function
• UltraLite for C++: CreateDatabase function
• UltraLite.NET: CreateDatabase method
• UltraLite for M-Business Anywhere: createDatabase method
• Accessing creation parameter values
• Timestamp-based downloads
• Concurrency in UltraLite

Example

To store a value such as '2000/12/05 10:50:53:700', set this creation parameter to 100000. This value truncates the timestamp after the first decimal place in the seconds component.