The VM Interface › Reporting Component › Report Control Statements › SORT Statement

SORT Statement

The SORT statement, identified by the statement Type SORT, is required. It allows the input accounting data to be sorted on up to five different fields. Each field or sort level is defined by the format pppllosd where:

ppp

is a three-digit number indicating the sort field's starting position. Refer to the VM Basic Accounting Table later in this chapter.

ll

is a two-digit number between 01 and 08 defining the length of the sort field in the VM Basic Accounting Table.

o

indicates the sort order:

A =

ascending (default)

D =

descending

s

is the summary print option that tells the Report Writer whether the user wants a summary line printed for this level and is defined as follows:

N or =

no summary line is printed at this level.

1, 2, or 3 =

single, double, or triple spacing before printing the summary line.

E =

eject to a new page after printing summary.

P =

eject to new page and reset page number to 1 after printing. (If either E or P is specified for the first [major] summary level, grand totals print on a page by themselves.)

d

indicates whether a Descriptive Header appears at this level.

The creation of any user sort control field may be omitted. If no sort control field is specified, the accounting data is arranged in the following default order:

• Start Date
• Start Time.

The maximum length of each user-defined sort control field is eight (8) characters. Sort field definitions of less than eight characters are padded with trailing blanks. In addition to a summary line at each of the five levels, the Report Writer automatically produces a final totals line at the conclusion of a report.

Each SORT statement must have a set code.

The following example illustrates a typical SORT statement:

            Firt Sort Level        Second Sort Level

1            10                     18

ASORT        30108AE1               01608A21

Report A is sorted on two levels. The more general level is project ID (begins at position 301 in the Basic Accounting Table), an 8-character field, sorted in ascending order. The E1 tells CA JARS to eject to a new page after printing summary lines, and include descriptive headers.

The second sort level is userid (position 16 in the Basic Accounting Table), an 8-character field sorted in ascending order. The 21 tells CA JARS to skip two lines before printing summary lines, and include descriptive headers.

The Print DDname Suffix can be used to tell the Report Writer to use different print file DD statements for each report. When this position is non-blank, the character is appended to CAIJSPRT and used as the DDname for the print file for this report. For example, CAIJSPRT is the DDname when the suffix character is a 1. When running under CMS, you identify a DDname with a FILEDEF command. For instance, you would modify the CAIJV050 EXEC to include the command:

FILEDEF CAIJSPRT DISK REPORT1 OUTPUT A1