DB2 tables PROGRAM VS Table COLUMNS used

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
SRI123
Member
Posts: 15
Joined: Wed Aug 12, 2009 12:18 pm

DB2 tables PROGRAM VS Table COLUMNS used

Post by SRI123 » Tue Dec 10, 2013 2:25 pm

Hi

Is there any way to get the list of the programs and DB2 table columns used in that program by using catalog table?

Like example:
PGM1 - EMPNO
PMG1 - EMPNAME
PGM2 - EMPNO
PGM2 - EMP-ADD
PGM2- EMP-SAL

Thanks

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