CL Command Reference - PRTSQLINF
CL Command List > PRTSQLINF Reference
Description:
The Print Structured Query Language Information (PRTSQLINF) command allows you to print information about the SQL statements in a program, SQL package, service program, or job. The information includes the SQL statements, the access plans used during the running of the statement, and a list of the command parameters which are defined either during the precompile of the source member for the object or when SQL statements are run.
Examples:
Example 1: Printing SQL Information
PRTSQLINF PAYROLL
This command will print information about the SQL statements contained in program PAYROLL.