aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Querying A DB2 Table Last Update Date