Specify Sort Options
The following figure shows the Sort Options phase of the Report Definition dialog that allows you to define the sort order of the columns in the final report, along with their associated ascending or descending sort options. The columns to be sorted in the report are marked with an asterisk (*) and their position on the screen (top to bottom) defines the sort order (first to last).
Code Pipeline Report Definition - Sort Options Screen
Command ===>
Select the columns to be sorted * with their options (Ascending or Descending)
and the sort order.
Column Name Sort Option
________________ _________________________________________________________
More: +
_ ACTION
_ ASSIGNMENT
_ DATE
_ NAME
_ VERSION
- Use the S line command to select fields to be sorted as shown in the following figure.
In this example, selecting the DATE field makes the date the first field to sort on and establish that sorting will be in ascending order.
Selecting Fields on the Sort Options ScreenReport Definition - Sort Options Top of data
Command ===>
Select the columns to be sorted * with their options (Ascending or Descending)
and the sort order.
Column Name Sort Option
________________ _________________________________________________________
More: +
_ ACTION
_ ASSIGNMENT
S DATE
_ NAME
_ VERSIONThe ASSIGNMENT field is selected next (following figure).
Selecting Additional Sort Options FieldsReport Definition - Sort Options
Command ===>
Select the columns to be sorted * with their options (Ascending or Descending)
and the sort order.
Column Name Sort Option
________________ _________________________________________________________
More: +
_ DATE * Ascending
_ ASSIGNMENT * Ascending
_ ACTION
_ NAME
_ VERSIONOvertyping the A (in Ascending) with a D changes the sort order from Ascending to Descending for the corresponding field as shown in the following figure.
Changing the Sort Order on the Sort Options ScreenReport Definition - Sort Options
Command ===>
Select the columns to be sorted * with their options (Ascending or Descending)
and the sort order.
Column Name Sort Option
________________ _________________________________________________________
More: +
_ DATE * Ascending
_ ASSIGNMENT * Descending
_ ACTION
_ NAME
_ VERSIONEnter the END command to display the JCL that will be submitted to run the report or extract.
Code Pipeline Report JCLFile Edit Edit_Settings Menu Utilities Compilers Test Help
-------------------------------------------------------------------------------
EDIT USER003.ISP48084.SPFTEMP7.CNTL Columns 00001 00072
Command ===> Scroll ===> CSR
****** ***************************** Top of Data ******************************
000001 //WZREPORT JOB ,,CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),
000002 // NOTIFY=USER003,TIME=5
000003 //*
000004 //* TYPE = TASK
000005 //* SORT = Y
000006 //* HEADING = TESTING WRPT AND WZZWRX WITH A LONG HEADING LINE
000007 //* DEST = R
000008 //* EXTRACT = USER003.NEW.FILE3
000009 //* PAGESIZE= 60
000010 //*
000011 //*********************************************************************
000012 //* CREATE EXTRACT FILE
000013 //*********************************************************************
000014 //****************** START SKEL WZU@TSO *******************************
000015 //*********************************************************************
000016 //ISPWTSO EXEC PGM=WZZRCBAT,PARM='ISPP/IKJEFT01',DYNAMNBR=64,
000017 // REGION=6M
000018 //STEPLIB DD DISP=SHR,DSN=ISPW.MPWM330.AUTHLINK
000019 //ISPLOG DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=121,BLKSIZE=1210)- In the JCL there is a DD statement, TEMPLATE, in step WZZWRP that contains the report criteria. The dataset that corresponds to the TEMPLATE DD can be saved in Code Pipeline and reused.
- Submit the JCL to produce a report.