Coding SQL statements in REXX applications

REXX procedures do not have to be preprocessed. At run time, the REXX interpreter passes statements that it does not understand to the current active command environment for processing.

The command environment can be changed to *EXECSQL to send all unknown statements to the database manager in two ways:

  1. CMDENV parameter on the STRREXPRC CL command
  2. address positional parameter on the ADDRESS REXX command

For more information about the STRREXPRC CL command or the ADDRESS REXX command, see the REXX/400 Programmer's GuideLink to PDF topic and the REXX/400 ReferenceLink to PDF topic.

Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.