z/OS DFSMSrmm Reporting
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


Specifying report type criteria

z/OS DFSMSrmm Reporting
SC23-6875-00

To specify report type basic record selection criteria, follow this procedure.

  1. Type S in the S column for a report type on the DFSMSrmm Report Types panel. Press the ENTER key.
  2. Type S in the S column on the DFSMSrmm Report Type panel as shown in Figure 1 to select the fields to use in your selection criteria and press the ENTER key. An asterisk in the S column indicates that the field is already used as a report selection criteria. The name of the report type that you selected appears in the title of this panel.

    The Typ (field type) data column displays the data type of the field. You can override the data type of the field by specifying a new data type, which is saved in the report type. The data type is used during report record selection and for converting the data into the report. The original field type is saved and can be restored by deleting the current value.

    Possible macro derived values are:
    B
    Bitstring (for example, X'A5FC39')
    C
    Character (for example, ABC or My Vol1)
    N
    Numeric (for example, 25)
    Possible user specified values are:
    F
    Binary (length 1,2,4, or 8 bytes)
    P
    Packed
    Z
    Zoned decimal
    ccc
    Any valid data type supported by your reporting tool, such as DT1, TM2
    Figure 1. Specifying report type criteria using the DFSMSrmm Report Type panel
      Panel  Help                                                                  
    ------------------------------------------------------------------------------
    EDGPG210               DFSMSrmm Report Type - EDGRXEXT      Row 1 to 29 of 188
    Command ===>                                                  Scroll ===> CSR 
                                                                                  
    Report type  : Extended Extract Records                                       
    Select a field name with S to specify a field selection criterion             
                                                                                  
    S Field name           Column header text                    Typ              
    - -------------------- ------------------------------------- ---
    * RXTYPE               Record type - C'X'                    C              
      XVVOLSER             Volume serial number                  C              
      XVPVOL               Previous volume in sequence           C                
      XVNVOL               Next volume in sequence               C                
      XVSTVOL              Stacked volume VolSer (SV/LV)         C                
      XVMDMVID             Multi-dataset multi-volume id         C                
    S XVCRDATE             Create date of volume record          C                
  3. Enter the record selection criteria on the DFSMSrmm Report Criteria panel, as shown in Figure 2, to select a subset of the input records for your report. DFSMSrmm only includes the records that meet the criteria that you specify as input to your report. Press the PF1 key with the cursor on any input field and a help panel describes the field and the valid values to be used. 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 compared. Type the exact value that 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. The I line command can be used to see the original field type, if it has been changed. Use the Conj (Conjunction) column to specify how the fields are logically connected.
    Figure 2. Specifying report type criteria using the DFSMSrmm Report Type Criteria panel
     Panel  Help
    -------------------------------------------------------------------------------
    EDGPG220           DFSMSrmm Report Type Criteria - EDGRVSCR    Row 1 to 2 of 2
    Command ===>                                                 Scroll ===>PAGE
    Report type  : List of  Volumes
    
    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 RVTYPE               EQ X                                       AND    1  C
      RVLCUID              EQ NE &Field=RVOWNID                              8  C
  4. Add, change, or delete any of the values on this panel and press the ENTER key to show your changes on the DFSMSrmm Report Criteria panel, as shown in Figure 2.
    Figure 3. Specifying report type criteria using the DFSMSrmm Report Criteria Details panel
    EDGPG221   DFSMSrmm Report Type Criteria Details - EDGRVSCR
                                                             
     Field name . . . . : RVTYPE                             
     Operation  . . . . . EQ                                 
     Enter "/" to select additional options:
        Select from available equated values 
     Or enter compare value(s):
     Compare value(s) . . X                                  
     Conjunction  . . . . AND                                
     Substring position .                                    
     Substring length . .                                    
     Orig field length  :   1          
     Type . . . . . . . . C            Original field type . . . : C  
  5. Press the END key on the DFSMSrmm Report Criteria panel, as shown in Figure 2, to save the report criteria and to return to the DFSMSrmm Report Types panel that was shown in Figure 2.
Related reading: See Running a report generator report.

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014