IBM Support

RUNSQL control of output listing

News


Abstract

The Run SQL (RUNSQL) command has been enhanced to include parameters for creating an output listing.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > RUNSQL control of output listing

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

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11164736