Changing a report definition
To change a report definition and save it in your user library, follow this procedure.
- Type S in the S column on the DFSMSrmm Report Definitions panel
as shown in Figure 1. Press the ENTER key.
If you change a report definition, that resides in the product library
or installation library, DFSMSrmm adds the changed report definition
to your user library.
Figure 1. Changing a report definition using the DFSMSrmm Report Definitions panel Panel Help ------------------------------------------------------------------------------ EDGPG020 DFSMSrmm Report Definitions Row 1 to 2 of 2 Command ===> Scroll ===>PAGE The following line commands are valid: A,D,G,H,J,L,M,N,S, and T S Name Report title Report type User id - -------- ------------------------------ ---------------------------- ------- EDGGR01 Scratch tapes by volume serial Extended Extract Records D094746 S BCKVOL Backup Volume List Extract Records for Volumes D094746 ******************************* Bottom of data ******************************** - Select the fields that you want in your report by typing a number in the CO column. Begin with the number 1 on the DFSMSrmm Report Definition panel, as shown in Figure 2. The fields are ordered from left to right across the report. The report definition name for the report that you selected appears in the title of the DFSMSrmm Report Definition panel. The panel displays the Report title, the Report footer, and the Reporting tool for this report. To group your data and produce a page break when the data content of the group field changes, enter a G (Group) in the CO column for the field name. Group field names do not appear as columns on the report, but appear as field names in the report header.
- Enter the sort fields in numerical order, beginning with the number 1 in the SO (Sort Order) column. Then enter the direction of the sorted data. Because the data for a group field must be in sorted sequence, this field must have a sort entry in the SO column. For example, the report definition that is defined on this panel has six columns of data. The left-hand column contains the volume serial number. The right-hand column contains the data set name of the first file on the volume. The data is grouped by the last change date of the volume record with the earliest date appearing at the top of the report and a new page printed when the date changes.
- Type S in the S column on one or more fields to select a subset
of input records for your report and press the ENTER key. (An asterisk
in the S column indicates that the field is already used as a record
selection criteria.)
Figure 2. Changing a report definition using the DFSMSrmm Report Definition panel Panel Help ------------------------------------------------------------------------------ EDGPG050 DFSMSrmm Report Definition - BCKVOL Row 1 to 22 of 214 Command ===> Scroll ===>PAGE Report title . . . Backup Volume List, created on &RHCRDATE(1,49,10,CH) + Report footer . . IBM Internal Reporting tool . : ICETOOL Report width: 187 Show minimum values: (N/Y) Show average values: (N/Y) Show maximum values: (N/Y) Show totals : (N/Y) Show counts : (N/Y) Enter "/" to select option Edit the help information for this report Use END to save changes or CANCEL The following line commands are valid: S, and R S CO SO Field name Column header text CW Len Typ - -- --- -------------------- ------------------------------------ --- --- --- * G 1A XVLCDATE Last change date of volume recor 10 10 C 1 XVVOLSER Volser 6 6 C 2 XVLCTIME Last change time of volume recor 10 6 C 3 XVEXPDTO Org. Exp. Date 14 10 C * 4 XVEXPDT Expiration date - current 10 10 C 5 XVLCUID Last change user id of volume 9 8 C * 6 XVDSNAM1 First file data set name 44 44 C * RXTYPE Record type - C'X' 6 1 C XVPVOL Previous volume in sequence 9 6 C XVNVOL Next volume in sequence 7 6 C - Enter the record selection criteria on the DFSMSrmm Report Criteria
panel, as shown in Figure 3, to select a subset
of the input records for your report. DFSMSrmm uses the records that
meet your criteria as input to your report. Use the S column to order
the listed fields from top to bottom or to add or change the record
selection criteria. Use the Op (Operator) column to specify the logical
operator that you want to use for comparing the field contents with
the values in the Compare value(s) column. Use the Compare value(s)
column to specify the values that you want to compare. Type the exact
value you want to compare because the comparisons are case sensitive.
The Compare value(s) field is a scrollable field, so that up to 100
characters can be entered. Use the Conj (Conjunction) column to specify
how the fields are logically connected.
Figure 3. Changing a report definition using the DFSMSrmm Report Criteria panel Panel Help ------------------------------------------------------------------------------ EDGPG060 DFSMSrmm Report Criteria - BCKVOL Row 1 to 4 of 4 Command ===> Scroll ===>PAGE Report title : Backup Volume List Use END to save changes or CANCEL The following line commands are valid: B,D,N,P,R,T, and I (for details) Operators: EQ = NE <> GT > GE >= LT < LE <= IN BW SE SN BO BM BZ NO NM NZ Conjunction: AND, OR, AND(, )AND S Field name Op Compare value(s) Conj Len Typ - -------------------- -- --------------------------------------- ---- --- --- + I RVLCDATE IN 1999/12/31,2000/01/31,2000/03/31,2000/0 AND 10 C RVDSNAM1 SE BACKUP AND 44 C RVEXPDT BW 1999/01/01,2000/12/31 AND 10 C RVTYPE EQ V AND 1 C RVTYPE 1 C ******************************* Bottom of data ******************************** - Add, change, or delete any of the values on the panel shown in Figure 4and press the ENTER key. Your changes are
displayed on the DFSMSrmm Report Criteria panel, as shown in Figure 3.
Figure 4. Changing a report definition using the DFSMSrmm Report Criteria Details panel EDGPG061 DFSMSrmm Report Criteria Details - BCKVOL Field name . . . . : RVLCDATE Operation . . . . . IN Enter "/" to select additional options: Select from available equated values Or enter compare value(s): Compare value(s) . . 1999/12/31,2000/01/31,2000/03/31,2000/04/30,2000/ + Conjunction . . . . AND Substring position Substring length . . Orig field length : Length . . . . . . : 10 Type . . . . . . . . C Original field type . . . : C - Press the END key on the DFSMSrmm Report Criteria panel, as shown in Figure 3, to save the report criteria and return to the DFSMSrmm Report Definitions panel that was shown in Figure 1.
Related reading: