Skip to Content

LINESPP statement

The LINESPP statement specifies the maximum number of lines that are printed per page for all reports that are produced by subsequent REPORT statements in the same job stream.

Fewer than the specified maximum lines might be printed to prevent splitting a group across pages.

Related topic

DOMBRPT1-utility

When used as a parameter of the REPORT statement, LINESPP applies only to the reports that are specified in that REPORT statement.

If this statement/parameter is omitted, reports are printed at 60 lines per page. The only valid abbreviations for LINESPP are LINES and L. The following figure shows the syntax of the LINESPP statement/parameter.


GUID-9EA93742-ABC7-4685-9E39-7EAC4EE2AA06-low.png

The following table describes the keyword for the LINESPP statement and parameter.

Keyword

Description

nn

(required)

Specifies the number of lines to print per page

Valid values are any number in the range 0, 10-99.

Specifying 0 causes no page headings to be generated.

Information
Example

This REPORT statement—which uses the LINESPP parameter— produces a Batch SQL Statement Analysis report that has 55 lines on each printed page.

REPORT(NAME(SQMBSTMT)
       LINESPP(55))

 

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

BMC AMI Apptune for Db2 13.1