LOCKING command with REPORT subcommand

This section describes the LOCKING command with the REPORT subcommand.

Usage

Use the REPORT subcommand to generate reports from records.

Usage notes

  • Up to five REPORT subcommands can be specified within each LOCKING command.

Syntax of the REPORT subcommand

Read syntax diagramSkip visual syntax diagramREPORTFROM/TO blockSCOPE(MEMBERGROUP)LEVEL(SUSPENSIONLOCKOUTDETAIL)DDNAME(LORPTDDddname)SPREADSHEETDD(ddname)ORDER blockINCLUDE/EXCLUDE block

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See Subcommand options for comprehensive descriptions of these options. The following list gives additional or specific descriptions of selected options, where appropriate.

LEVEL
Specifies the level of the report. Both the SUSPENSION and LOCKOUT keyword can be used together in the same REPORT subcommand.
SUSPENSION
Generates a lock suspension report. This is the default level.
LOCKOUT
Generates a lockout report.
DETAIL
Generates a detail report.
SPREADSHEETDD
Specifies that lock suspension report data should be written to the specified data set. The data is written in a format that can be imported by spreadsheet programs. The data set should be allocated using the following attributes:
RECFM:
VB
LRECL:
1 200 or greater

Use this subcommand option only together with LEVEL(SUSPENSION), which is the default if LEVEL(LOCKOUT) is not specified. See also Example using REPORT with LEVEL, ORDER, and SPREADSHEETDD options.

This subcommand option accumulates additional locking data. When written to the specified data set, the individual fields are separated by a separator character (a colon) so that workstation-based spreadsheet programs can import the data for further evaluation. When you download the data set to a client, ensure that you specify ascii or text, not binary, as transfer type in your file transfer program. This ensures that the necessary EBCDIC to ASCII conversion is performed.

For more information about using lock suspension report data, see the Report Reference (Locking Report).

Example using REPORT with LEVEL, ORDER, and INCLUDE options

This example specifies the following:
  • A lock suspension report
  • Sorted by plan name
  • Data is included that is only associated with the location in the range of LOCN01 to LOCN05
REPORT
   LEVEL   (SUSPENSION)
   ORDER   (PLANNAME)
   INCLUDE (LOCATION(R(LOCN01 LOCN05)))

Example using REPORT with FROM, TO, LEVEL, ORDER, and EXCLUDE options

This example specifies the following:
  • A lockout report
  • Sorted by plan name within primary authorization ID within correlation name
  • Records are used with the time and date range of 10:00 a.m. on 18 March 2001 to noon on 19 March 2001
  • Data is excluded that is associated with the following locations:
    • LOCN10
    • LOCN12
    • LOCN15
    • LOCN20
REPORT
   FROM    (03/18/01,10:00:00.00)
   TO      (03/19/01,12:00:00.00)
   LEVEL   (LOCKOUT)
   ORDER   (CORRNAME-PRIMAUTH-PLANNAME)
   EXCLUDE (LOCATION(LOCN10 LOCN12 LOCN15 LOCN20))

Example using REPORT with LEVEL, ORDER, and SPREADSHEETDD options

This example specifies the following:
  • A lock suspension report
  • A sort order by PAGESET identifier within DATABASE identifier, which is the default, but any other ordering will do
  • The data set TEST1DD where the Locking report is written in a spreadsheet-compatible format
REPORT
   LEVEL   (SUSPENSION)
   ORDER   (DATABASE-PAGESET)
   SPREADSHEETDD   (TEST1DD)