Hi,
This is my first time posting in this forum. I am very green in DB2 admin so I would really appreciate your help.
The company had a data warehouse on DB2 7.1 on a sun solaries 8
I want to know how to retreive creation date from any table
ThanksDid you mean to post this in the SQL forum?
Regards,
hmscott|||Right church, wrong pew...
no matter...do this against your database...it should show you the definition of your tables and columns
SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'your owner id'
And try here...
http://www.dbforums.com/f8/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment