IBM Support

Detailed File Field Description for File QADSPPGM, Format QWHDRPPR for the DSPPGMREF output file

Troubleshooting


Problem

Here is a listing of the field descriptions for the output file format QWHDRPPR

Resolving The Problem

When the DSPPGMREF command is used with its parameter set to OUTFILE, the output file is based on the format QWHDRPPR from file QADSPPGM.

Example
DSPPGMREF PGM(PGMNAME) OUTPUT(*OUTFILE) OUTFILE(FILENAME)

Here is a listing of the field names for format QWHDRPPR. This listing is current as of R720:

External    Field Text                                        
Field Name  Description
WHLIB       Library
WHPNAM      Program
WHTEXT      Text 'description'
WHFNUM      Number of objects referenced
WHDTTM      Retrieval date:  century/date/time
WHFNAM      Object referenced: 1=*EXPR
WHLNAM      Library referenced: 1=*EXPR
WHSNAM      File name in source program: =*EXPR
WHRFNO      Number of record formats referenced. -1=See WHRFNB
WHFUSG      1=I,2=O,3=I/O,4=U,5=I/U,6=O/U,7=I/O/U,8=Not specified,0=Not available
            **
If a file reference in the program is not used for input or output, such as
                             CREATE or DROP, WHFUSG is set to 8.  
                             An example of an i/o usage is an SQL INSERT, UPDATE, DELETE where the data in the file is
                             modified in some way.
WHRFNM      Record format referenced
WHRFSN      Format level identifier
WHRFFN      Number of fields
WHOBJT      Object type: F=File, P=Program, D=Data area
WHOTYP      Object type
WHSYSN      System Name (Source System, if file is DDM)
            **
This field is set to the system name where the DSPPGMREF is executed.
WHSPKG      PGM=P, SQLPKG=S, SRVPGM=V, MODULE=M, QRYDFN=Q
            **
This field is not specific to DDM files.  It the type of the referencing object type. Values are:  
                            PGM=P, SQLPKG=S, SRVPGM=V, MODULE=M, QRYDFN=Q
                            For example,
                            DSPPGMREF PGM(your-lib/PGM1) OBJTYPE(*ALL)  output(*outfile) outfile(qtemp/out1)
                            If you have a *SRVPGM and a *PGM in your-lib named PGM1, you can tell which object the reference applies.
WHRFNB      Number of record formats referenced.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHtAAM","label":"Programming ILE Languages"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Historical Number

547903006

Document Information

Modified date:
18 January 2023

UID

nas8N1012565