EXEC QUERY precedes the 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 The 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 The 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, Section 'The REPORT Generator').