MVSFORUMS.com

[yadav2005]

In our test system new tables are being created by users.Is there any way to know the which is the latest table created by users as per the latest time.

Say user1 has created a table on Monday.user2 has created a table on tuesday and user3 has created a table on wednesday , but i do not know what tables have been created.I want a query which should tell the latest tables created as per descending order of time which means i should have a display for table 3 first ,then table 2 and table 1.

I hope i am clear in my requirement.

[programmer1]

The above is the answer to your other post.

Check SYSIBM.SYSTABLES for your above requirement.
_________________
Regards,
Programmer

[acevedo]