Find All DB2 tables

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Adybong
Member
Posts: 2
Joined: Wed Apr 17, 2013 12:06 pm
Location: INDIA

Find All DB2 tables

Post by Adybong » Thu May 23, 2013 2:50 pm

Hi All,

Under my Id I've only access to say DB**** region . I want to see the number of tables under this region DB****. So can you please help me with a Query ( Only by Querty from Spool Not from any tool ) or the Way to See the Tables Under This Region.

Thnaks In Advance...
With Regards,
AdyBong...

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu May 23, 2013 10:14 pm

Look in the system ables - cannot recall od=ff the top of my head the names but something like systables.
Regards
Nic

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others