Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Apptune for Db2 13.1.

LINESPP statement and parameter

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.

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))

Related topic

DOMBRPT1-utility

 

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

BMC AMI Apptune for Db2 12.1