Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

EXPAND statement and parameter

The EXPAND statement specifies that all groups in the reports will be expanded and printed in their expanded format.

It applies to all reports that are produced by subsequent REPORT statements in the same job stream. The NOEXPAND statement specifies that only the data included on initial display of the report online are included in subsequent printed reports. NOEXPAND is the default.

When used as a parameter of the REPORT statement, EXPAND or NOEXPAND relates only to the reports that are specified in that REPORT statement. An EXPAND or NOEXPAND parameter of a REPORT statement overrides any previously specified EXPAND or NOEXPAND statement.

The only valid abbreviation for EXPAND is EXP, and the only valid abbreviation for NOEXPAND is NOEXP. The following figure shows the syntax of the EXPAND statement and parameter.

GUID-6515CD0B-B28E-44CF-98C0-9700E08248BD-low.png


Example

In the following example, the EXPAND statement causes all of the reports that are specified in the first REPORT statement to be expanded, but not the report in the second REPORT statement. The NOEXPAND parameter overrides the previous EXPAND statement, but applies only to the report in the same REPORT statement.

EXPAND
REPORT(NAME(BACCTST,BSTATLT))
REPORT(NAME(BACCTDR) NOEXPAND)




Related topic

DOMBRPT1-utility

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*