(IBM i fans only) Retrieving Files Used in Programs, SQL packages, Service programs, Modules, Query definitions in an IBM i Library
In this post, we’ll explore how to efficiently retrieve program files used in queries within an IBM i library using the DPR command, along with its associated CLP ( DPRCL ) and SQL RPGLE program ( DPRRPG ). This combination allows users to dynamically fetch program file references based on various filters, enhancing the management of programs in the IBM i environment. Overview of Components 1. The DPR Command The DPR command serves as the entry point for retrieving program files. It accepts two parameters: the library name and the object type. Below is the source code for the DPR command: CMD PROMPT('Show Pgm Files via DSPPGMREF') /* COMMAND PROCESSING PROGRAM IS: DPRCL */ PARM KWD(LIBRARY) TYPE(*CHAR) LEN(10) MIN(1) ...