EXEC REPORT precedes the command sequences of the REPORT generator.
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 a 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.
Commmands for the report can be specified in <reportlines> (see the QUERY Manual, Section 'The REPORT Generator').
Results specified in REPORT commands can be passed to the application program via <parameter-output>.
If the master-detail functionality of the REPORT generator is used, it has to be taken into account that the SELECT statement of the MASTER qualification was executed within the program and generated a result table. To display the MASTER table, only the keyword MASTER is required, without SELECT statement. The DETAIL functionality is valid without any restrictions.