File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Querying A DB2 Table Last Update Date
Joined: Dec 27, 2000
Mar 07, 2002 22:23:00
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?
Joined: Jul 09, 2001
Mar 08, 2002 07:57:00
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
It is sorta covered in the
JavaRanch Style Guide
subject: Querying A DB2 Table Last Update Date
Cannot perform SQL UPDATE null
Update Table Nested Query (Using Function)
help with batch processing large number of db records
Assignment Log Project
Timestamp advanced 4 hours
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015