DISPLAY Operator
DISPLAY Operator (for Beginners)
Summary
For extensive information, go through the DISPLAY Operator for Experienced
DISPLAY operator prints the values or characters of specified numeric or character fields in separate list data set.
Syntax -
Required Operands
- FROM - FROM parameter specifies ddname of the input file.
- LIST - listdd specifies the list dataset ddname to be created by ICETOOL LIST operation.
- ON - ON operator specifies the field(s) used for DISPLAY operation.
Optional Operands
- TITLE, PAGE, DATE, DATENS, YDDD, YDDDNS, TIME and TIMENS - Specify the elements in the title lines at the top of each page.
- TLEFT - Specifies title strings are left-justified for each other.
- TFIRST - Specifies the title lines are only printed on the first page.
- NOCC - Suppresses carriage control characters.
- HEADER - Specifies one, two, or three lines heading to be printed for the corresponding ON the field.
- NOHEADER - Suppresses the heading line.
- LINES - Specifies the number of lines per page.
- BLANK and PLUS - BLANK causes a blank, rather than a PLUS for the positive sign.
- TOTAL, MAXIMUM, MINIMUM, AVERAGE and COUNT – Specifies the overall statistics to appear after the data columns for the report.
- EDCOUNT - Specifies how the overall count is formatted for printing.
- LIMIT - Specifies the limit for the number of invalid decimal values.
- VSAMTYPE - VSAMTYPE operand specifies the record format for a VSAM input file (F or V).
- WIDTH - Specifies the line length and LRECL length for the list data set.
- LONGLINE - Specifies the calculated line length to be a maximum of 8191 bytes.
- BREAK - Specifies the break field to be used to divide the report into sections.
- BTITLE - Specifies a string to appear in the section title.
- BTOTAL, BMAXIMUM, BMINIMUM, BAVERAGE and BCOUNT – Specify the section where the statistics appear after each section's data is displayed.
- EDBCOUNT - Specifies how the section count is formatting for printing.
- INDENT - Specifies the number of blanks used to indent the report.
- BETWEEN - Specifies the number of blanks used between the data columns.
- TBETWEEN - Specifies the number of blanks used between title elements.
- STATLEFT - Aligns the statistic strings to the left from the first column.
- UZERO - Causes -0 to be treated as unsigned, that is, as 0.
- LISTSDB - LISTSDB specifies to ICETOOL that the BLKSIZE should select as the system-determined optimum block size for the LIST data set in the same way as for installation option SDBMSG=YES.
- LISTNOSDB - LISTSDB specifies to ICETOOL that the BLKSIZE should select as the system-determined optimum block size for the LIST data set in the same way as for installation option SDBMSG=NO.
Example -
Scenario - Adds a header to the list file and displays rows statistics information.
INPUT - MATEPK.INPUT.PSFILE
BROWSE MATEPK.INPUT.PSFILE Line 00000000 Col 001 080
Command ===> Scroll ===> CSR
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
********************************* Top of Data **********************************
001 PAWAN MAINFRAME JPM AP IN
002 SRINIVAS TESTING ORACLE TG IN
003 SRIDHAR SAS CG OR US
004 VENKATESH ABAP CSC CA US
005 RAVI HADOOP CTS FL US
006 PRASAD HR INFOSYS MI US
007 RAJA TESTING IBM CA US
******************************** Bottom of Data ********************************JCL -
----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
***************************** Top of Data ******************************
//MATEPKDI JOB (123),'MATEPK',CLASS=A,MSGCLASS=A,MSGLEVEL=(1,1),
// NOTIFY=&SYSUID
//*
//STEP01 EXEC PGM=ICETOOL
//INDD DD DSN=MATEPK.INPUT.PSFILE,DISP=SHR
//LISTDD DD DSN=MATEPK.OUTPUT.PSFILED,
// DISP=(NEW,CATLG,DELETE),VOLUME=SER=DEVHD4,
// SPACE=(TRK,(1,1),RLSE),UNIT=SYSDA,
// DCB=(DSORG=PS,RECFM=FB,LRECL=80,BLKSIZE=800)
//TOOLIN DD *
DISPLAY FROM(INDD) LIST(LISTDD) -
TITLE('EMPLOYEE REPORT') -
PAGE DATE TIME -
HEADER('ENO') HEADER('NAME') HEADER('TECHNOLOGY') HEADER('COMPANY')-
ON(1,3,CH) ON(6,14,CH) ON(20,19,CH) ON(40,10,CH) -
BLANK -
COUNT('NUMBER OF RECORDS: ') EDCOUNT(U04)
/*
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
**************************** Bottom of Data ****************************
OUTPUT - MATEPK.OUTPUT.PSFILED
BROWSE MATEPK.OUTPUT.PSFILED Line 00000000 Col 001 080
Command ===> Scroll ===> CSR
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
********************************* Top of Data **********************************
EMPLOYEE REPORT - 1 - 03/05/22 03:14:08
ENO NAME TECHNOLOGY COMPANY
--- -------------- ------------------- ----------
001 PAWAN MAINFRAME JPM
002 SRINIVAS TESTING ORACLE
003 SRIDHAR SAS CG
004 VENKATESH ABAP CSC
005 RAVI HADOOP CTS
006 PRASAD HR INFOSYS
007 RAJA TESTING IBM
NUMBER OF RECORDS: 7
******************************** Bottom of Data ********************************TOOLMSG (SDSF SPOOL) - Verify TOOLMSG for the return code of the submitted job.
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9
********************************* TOP OF DATA ********************************************
1ICE600I 0 DFSORT ICETOOL UTILITY RUN STARTED
ICE650I 0 VISIT http://www.ibm.com/storage/dfsort FOR ICETOOL PAPERS, EXAMPLES AND MORE
ICE632I 0 SOURCE FOR ICETOOL STATEMENTS: TOOLIN
ICE630I 0 MODE IN EFFECT: STOP
DISPLAY FROM(INDD) LIST(LISTDD) -
TITLE('EMPLOYEE REPORT') -
PAGE DATE TIME -
HEADER('ENO') HEADER('NAME') HEADER('TECHNOLOGY') HEADER('COMPANY')-
ON(1,3,CH) ON(6,14,CH) ON(20,19,CH) ON(40,10,CH) -
BLANK -
COUNT('NUMBER OF RECORDS: ') EDCOUNT(U04)
ICE643I 0 WIDTH OF REPORT IS 0121 BYTES
ICE627I 0 DFSORT CALL 0001 FOR COPY FROM INDD TO E35 EXIT COMPLETED
ICE603I 0 INFORMATION PRINTED IN LISTDD DATA SET
ICE628I 0 RECORD COUNT: 000000000000007
ICE602I 0 OPERATION RETURN CODE: 00
ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE: 00
******************************** BOTTOM OF DATA ******************************************Explaining Solution -
- INDD - Specifies the ddname for input file.
- OUTDD - Specifies the ddname for output file.
- TOOLIN DD * - Specifies the ICETOOL statements for DFSORT.
- TOOLMSG - Specifies where to write the ICETOOL processing messages.
- DFSMSG - Specifies where to write the DFSORT processing messages.
- DISPLAY FROM(INDD) LIST(LISTDD) - Prints the report into LISTDD using INDD records.
- TITLE('EMPLOYEE REPORT') - Places the title left justified.
- PAGE DATE TIME - Prints page number, printed date and time on the same line where title printed.
- HEADER('ENO') HEADER('NAME') HEADER('TECHNOLOGY') HEADER('COMPANY') - Prints the headers based on the ON parameter length and with three lines gap in between headers.
- ON(1,3,CH) ON(6,14,CH) ON(20,19,CH) ON(40,10,CH) - Conditions for headers.
- BLANK - Prints blank line.
- COUNT('NUMBER OF RECORDS: ') EDCOUNT(U04) - Prints the count at the end.