INF: Retrieving Current Timestamp from Data Row

ID Number: Q45260

1.10 1.11 4.20

OS/2

Summary:

Dbtsnewlen, dbtsnewval, and dbtsput should not be called before a

browse mode update is attempted. The select statement retrieves the

current timestamp from the data row, not dbtsnewval. If you issue

dbtsnewval before the browse mode update, correct results will not be

returned. This is because dbtsnewval does not have any way of knowing

what is the next timestamp value that will be assigned by the SQL

Server. A new timestamp can be generated only when an update is

actually performed. You can read the original timestamp with a select

statement.

Additional reference words: DB-LIBRARY db-lib dblib