z/OS DFSORT Application Programming Guide
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


Tailored report

z/OS DFSORT Application Programming Guide
SC23-6878-00

You can tailor the output in the list data set using various operands that control title strings, date, time, page number, headings, lines per page, field formats, total, maximum, minimum, and average values for the columns of numeric data, and the record count. The optional operands can be used in many different combinations to produce a wide variety of report formats. For example, if you specify FROM, LIST, BLANK, TITLE, PAGE, DATE, TIME, HEADER and AVERAGE operands, and ON operands for 10-byte character and 7-byte zoned decimal fields, the output in the list data set can be represented as follows:

 title        - p -        mm/dd/yy        hh:mm:ss

 header         header
 ----------   --------
 characters         sd
 .                   .
 .                   .
 .                   .

 average            sd

By default, a control character occupies the first byte of each list data set record. The NOCC operand can be used to suppress the control characters. The title lines (up to 3) are printed at the top of each page of the list data set. The first title line contains the elements you specify (title strings, page number, date and time) in the order in which you specify them. The second and third title lines contain the title strings you specify. By default, eight blanks appear between title elements, the title strings are centered with respect to each other, and the title lines appear on every page. The TBETWEEN(n) operand can be used to change the number of blanks between title elements. The TLEFT operand can be used to left-justify the title strings with respect to each other. The TFIRST operand can be used to only print the title lines on the first page. A blank line is printed after each title line.

Your specified headings (underlined) are printed after the title line on each page to indicate the contents of each column, followed by a line for each record showing the characters and numbers in the fields of that record. Your specified headings can be one, two or three lines. Headings for character fields are left-justified and headings for numeric fields are right-justified.

Your specified statistical lines (total, maximum, minimum, average, and count, and their associated strings) are printed for selected numeric fields and the record count, after the columns of data. The associated strings can be printed in the first column or to the left of it.

The fields are printed in columns in the same order in which they are specified in the DISPLAY statement. Character fields are left-justified and numeric fields are right-justified. For numeric fields, leading zeros are suppressed, a - is used for the minus sign, and a blank is used for the plus sign (you can specify PLUS rather than BLANK if you want a + to be used for the plus sign).

Formatting items can be used to change the appearance of individual numeric fields in the report with respect to separators, number of digits, decimal point, decimal places, signs, leading zeros, division by 10, 100, 1000, 10000, 100000, 1000000, 1000000000, 1024, 1048576 (1024*1024), or 1073741824 (1024*1024*1024), leading strings, floating strings, and trailing strings. Formatting items can also be used to insert leading or trailing strings for character fields.

The column widths are dynamically adjusted according to the length of the headings and the maximum number of bytes needed for the character or numeric data.

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014