News
Abstract
The Run SQL (RUNSQL) command has been enhanced to include parameters for creating an output listing.
Content
The Run SQL (RUNSQL) command can be used to execute a single SQL statement. The RUNSQL command differs from other commands in that the SQL statement text is provided directly to the command via the SQL command parameter.
RUNSQL has been enhanced to include parameters to direct Db2 for i to create an output listing.
The new parameters (OPTION, PRTFILE & SECLVLTXT) work the same as described on the RUNSQLSTM command.
Parameter description Parameter name Default & optional value
Source listing options . . . . . OPTION *NOLIST or *LIST
Print file . . . . . . . . . . . PRTFILE QSYSPRT
Library . . . . . . . . . . . *LIBL
Second level text . . . . . . . SECLVLTXT *NO or *YES
Was this topic helpful?
Document Information
Modified date:
13 January 2020
UID
ibm11164736