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

to identify the tables having particular fields.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prabhucs01
Warnings : 1

New User


Joined: 07 Mar 2005
Posts: 43

PostPosted: Fri Nov 20, 2009 10:29 pm
Reply with quote

Which SYSIBM table has to be queried to identify the tables having certain fields.

for example it there are 100 tables in the dataset we have to know which all tables have that particular field.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Nov 20, 2009 10:42 pm
Reply with quote

vsn 7 sql reference

vsn 7 DB2 sql reference D.0 Appendix D. DB2 catalog tables

vsn 8 db2 SQL Reference

vsn 8 db2 sql referenceF.0 Appendix F. DB2 catalog tables
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 How to identify the transaction categ... IMS DB/DC 3
No new posts Identify Program Insert DB2 7
No new posts Need to fetch data from so many DB2 t... DB2 9
No new posts Concatenate 2 fields (usage national)... COBOL Programming 2
No new posts Identify unused (junk) REXX scripts TSO/ISPF 30
Search our Forums:

Back to Top