IBM Support

RUNSQLSTM command - OPTION parameter added to control listing

News


Abstract

RUNSQLSTM command - OPTION parameter added to control listing

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > RUNSQLSTM command - OPTION parameter added to control listing

A new Source listing options (OPTION) parameter has been added to the Run SQL Statements (RUNSQLSTM) command.
The OPTION parameter can be used to directly control the command output file, avoiding unnecessary spool file accumulation.
  • *LIST (DEFAULT) - A complete listing with the contents of the source and all errors is generated.
  • *NOSRC - A listing with only the messages is generated.
  • *ERRLIST - A complete listing is generated only if errors greater than the ERRLVL parameter are encountered during processing.
  • *NOLIST - No listing is generated. If errors greater than the ERRLVL parameter are encountered during processing, the messages will be sent to the joblog.

[{"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:
14 January 2020

UID

ibm11167394