USING (designate column headings and record fields)


USING designates column headings and record contents for each named record field specified with USING.

Only one USING statement is required. The USING statement selects the column heading from an internal data dictionary. To specify your own column heading that is not in the dictionary, set a variable to a literal (maximum of eight alphanumeric characters). Then specify the variable name in the USING statement, as described in User-defined data. Column headings are printed on lines 5 and 6, with the corresponding underlines on line 7 of the report.

Column headings and data appear on the report line in the order specified by the USING statement, reading from left to right. If an undefined field name or variable is specified, it does not appear on the report. If the column headings do not fit within the page width, the headings are truncated.

Syntax

USING Vn. . . Vn

where Vn represents the record field names shown in the Reference-for-PERFORMANCE-REPORTER or user variables defined by SET.

Note

Depending on the record field widths, use of more than eight names can cause truncation. More than 11 field names generally cause both truncation and unpredictable results.

Usage

To continue a list of variables on the next line, use a hyphen (-). A hyphen can be used only to continue variables to another line, not to continue statements.

Note

The variables listed on the USING statement have implied DEFINE statements associated with them that are used unless a previous DEFINE statement for the variable has been specified.

USING fixes the meaning of a variable for the duration of the PRL run. This occurs on the first use; subsequent uses are ignored. The effect of the USING statement is to make the variable attribute length and the decimal significance unalterable.

If the variables listed in a USING statement require special editing characteristics, consider placing a DEFINE statement before the USING statement. For further information on DEFINE, see DEFINE-define-variable-attributes-optional.

The maximum number of variables in a USING statement is limited to the number of variables that can fit on a print line. The default print line is 132 characters long.

To change the width of the print line, use

SET WIDTH=xxx

You can increase the size of the print line to up to 255 print positions.

Example

SET TITLE = 'SUMMARY TRANSACTION ROSTER'
SET TITLE = 'MAINVIEW for CICS PAGE ALLOCATION MAP ANALYSIS'
SELECT TYPE 17 RECORDS FROM CMRSTATS
USING CMRDATE CMRTIME -
              PAMCTLP -
              PAMTELP -
              PAMMIXP -
              PAMISOP -
              PAMSHRP -
              PAMRPLP -
              PAMPGMP -
              PAMDSAT -
              PAMTREE -
              PAMGETVT
   REPORT
 END



 

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