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.
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
Was this topic helpful?
Document Information
Modified date:
18 January 2023
UID
nas8N1012565