'exec report' precedes 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 REPORT 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.
Commmands for the report can be specified in <reportlines> (see the QUERY Manual, chapter The REPORT Generator).
Results specified in REPORT commands can be transferred 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 named result table. To display the master table, only the keyword master is required, without the select statement. The detail functionality is valid without any restrictions.