'exec query' precedes command sequences of QUERY routines.
'progname' determines a program name for the REPORT page. The value can be tranferred as a character string constant and can have up to 8 characters.
'version' determines the version number for the REPORT page. The value can be transferred as a character string constant and can have up to 8 characters.
'header' determines the heading for a REPORT page. The heading can be transferred as a character string constant or host variable and can have up to 40 characters.
In <optionlist>, options can be specified for the QUERY command. The following options are valid:
autocommit: A commit statement is executed after each SQL statement.
setoff: The interactive modification of SET parameters (see the QUERY manual, chapter User-specific SET Parameters) is suppressed during REPORT execution.
setlocal: This option allows a temporary modification of the SET parameters (see the QUERY manual, chapter User-specific SET Parameters); i.e., after leaving the REPORT display, the SET parameters are reset to the values valid before calling REPORT. If the option is not specified each modification of the SET parameters has a global effect; i.e., this modification is valid up to the next change of the SET parameters.
Commands for QUERY can be specified in <queryline> (see the QUERY Manual).
Results specified in REPORT commands can be transferred to the application program by means of <parameter-output> (see the QUERY Manual, chapter The REPORT Generator).