IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

query to list the table names
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
kacks7

New User


Joined: 22 Sep 2010
Posts: 33
Location: chennai(india)
PostPosted: Sat Oct 02, 2010 3:19 pm
 Reply with quote
hi frnds,
can anyone help me to list the table names created under my table space. is there any query to do this.???
Back to top
View user's profile Send private message
cdhami

New User


Joined: 24 Jan 2006
Posts: 28
PostPosted: Sat Oct 02, 2010 6:10 pm
 Reply with quote
You can find it in sysibm.systables or systablespaces tables

Thanks
CD
Back to top
View user's profile Send private message
kacks7

New User


Joined: 22 Sep 2010
Posts: 33
Location: chennai(india)
PostPosted: Tue Oct 05, 2010 3:32 pm
 Reply with quote
hi cd,

thanks a lot icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts RC query -Time column CA Products 3
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us