wood burning stoves 2.0*
The moose likes JDBC and the fly likes Querying A DB2 Table Last Update Date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Querying A DB2 Table Last Update Date" Watch "Querying A DB2 Table Last Update Date" New topic
Author

Querying A DB2 Table Last Update Date

Rudy Yeung
Ranch Hand

Joined: Dec 27, 2000
Posts: 183
Grateful if you can let me know if there is anyway I can query the last update date stamp of a table using SQL or other means. Is there another table in a database that keeps track of the table information?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

you can use a correlated subquery:
"select id, name, hiredate from emp where hiredate = (select max(hiredate) from emp)"
I'm pretty sure this is the same for DB2 also
Jamie
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Querying A DB2 Table Last Update Date
 
Similar Threads
help with batch processing large number of db records
Timestamp advanced 4 hours
Assignment Log Project
Update Table Nested Query (Using Function)
Cannot perform SQL UPDATE null