-
I'm seeking your expert guidance from DB2 DBA
Hi,
I am a new db2 database developer.
I'm attempting to run a select count query using ‘ POSTED TIMESTAMP’ for a legacy production database, but each time I get a different count. It seems data is constantly changing. To recognize newly added rows
Is there a seeded 'WHO' column at the table level in DB2 that will identify when the last insert/update/delete done on the db2 table?
Additionally, how to write a select query on a db2 temporal table using timestamps to locate records last insert/update/delete.
I'd be extremely grateful for an expert's response on this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|