Example: Displaying program reference

 

To see what objects are used by an application requester (AR) program, you can enter a command as follows.

DSPPGMREF PGM(SPIFFY/PARTS1) OBJTYPE(*PGM)

On the requester you can get a list of all the collections and tables used by a program, but you are not able to see on which relational database they are located. They might be located in multiple relational databases. The output from the command can go to a database file or to a displayed spooled file. The output looks like this:

File  . . . . . :   QPDSPPGM                         Page/Line   1/1
Control . . . . .                                    Columns     1 - 78
Find  . . . . . .
 
3/29/92               Display Program References DSPPGMREF Command Input Program . . . . . . . . . . . . . . . . . . :   PARTS1
Library . . . . . . . . . . . . . . . . . . :   SPIFFY Output  . . . . . . . . . . . . . . . . . . :   *
Include SQL packages  . . . . . . . . . . . :   *YES Program . . . . . . . . . . . . . . . . . . :   PARTS1
Library . . . . . . . . . . . . . . . . . . :   SPIFFY Text 'description'. . . . . . . . . . . . . :   Check inventory for parts Number of objects referenced  . . . . . . . :   3
Object  . . . . . . . . . . . . . . . . . . :   PARTS1
Library . . . . . . . . . . . . . . . . . . :   SPIFFY Object type . . . . . . . . . . . . . . . . :   *PGM Object  . . . . . . . . . . . . . . . . . . :   QSQROUTE Library . . . . . . . . . . . . . . . . . . :   *LIBL Object type . . . . . . . . . . . . . . . . :   *PGM Object  . . . . . . . . . . . . . . . . . . :   INVENT Library . . . . . . . . . . . . . . . . . . :   SPIFFY Object type . . . . . . . . . . . . . . . . :   *FILE File name in program  . . . . . . . . . . . :   
File usage  . . . . . . . . . . . . . . . . :   Input

To see what objects are used by an application server (AS) SQL package, you can enter a command as follows:

DSPPGMREF PGM(SPIFFY/PARTS1) OBJTYPE(*SQLPKG)

The output from the command can go to a database file or to a displayed spooled file. The output looks like this:

File  . . . . . :   QPDSPPGM                         Page/Line   1/1
Control . . . . .                                    Columns     1 - 78
Find  . . . . . .
 
3/29/92               Display Program References DSPPGMREF Command Input Program . . . . . . . . . . . . . . . . . . :   PARTS1
Library . . . . . . . . . . . . . . . . . . :   SPIFFY Output  . . . . . . . . . . . . . . . . . . :   *
Include SQL packages  . . . . . . . . . . . :   *YES SQL package . . . . . . . . . . . . . . . . :   PARTS1
Library . . . . . . . . . . . . . . . . . . :   SPIFFY Text 'description'. . . . . . . . . . . . . :   Check inventory for parts Number of objects referenced  . . . . . . . :   1
Object  . . . . . . . . . . . . . . . . . . :   INVENT Library . . . . . . . . . . . . . . . . . . :   SPIFFY Object type . . . . . . . . . . . . . . . . :   *FILE File name in program  . . . . . . . . . . . :   
File usage  . . . . . . . . . . . . . . . . :   Input

 

Parent topic:

Displaying objects used by programs