File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Querying A DB2 Table Last Update Date

 
Rudy Yeung
Ranch Hand
Posts: 183
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic