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:
- CMDENV parameter on the STRREXPRC CL command
- 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 Guide topic and the REXX/400 Reference topic.
Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.