Example 1. CF (by field) prefix command

This example shows how to enter redefines criteria using the CF (by field) prefix command.

  Process   Options   Help                                                      
 ───────────────────────────────────────────────────────────────────────────────
 Z Data Tools                 Field Selection/Edit                 Line 1 of 11 
 Command ===> _____________________________________________________ Scroll CSR  
                                                                                
 ----------- Criteria - Enter 1 or 2 to specify expression by field ----------- 
 1 Id :                                                                        + 
 2 Sel:                                                                        + 
 Offset      0                                                      CCSID _____ 
 Cmd Seq SHE Ref Field Name                           Picture  Type Start Length
                 ****  Top of data  ****                                        
 ___ ___       1 1 REDEFINES-LAYOUT                             AN      1      5
 ___ ___       2  2 REDEF-TYPE                        X         AN      1      1
 cf            3  2 DATA-A                                      AN      2      4
 ___ ___       4   3 DATA-A1                          XX        AN      2      2
 ___ ___       5   3 DATA-A2                          XX        AN      4      2
 cf            6  2 DATA-B REDEFINES DATA-A                     AN      2      4
 ___ ___       7   3 DATA-B1                          99        ZD      2      2
 ___ ___       8   3 DATA-B2                          99        ZD      4      2
 cf            9  2 DATA-C REDEFINES DATA-A                     AN      2      4
 ___ ___      10   3 DATA-C1                          S9(4)     BI      2      2
 ___ ___      11   3 DATA-C2                          S9(4)     BI      4      2
                 ****  End of data  ****                                        

Type the CF command next to a field that has a REDEFINES clause or is the target of a REDEFINES clause and then press Enter.

The REDEFINES Criteria panel is displayed for the first field, DATA-A.

  Process   Options   Help                                                      
 ───────────────────────────────────────────────────────────────────────────────
 Z Data Tools   REDEFINES Criteria: DATA-A                         Line 1 of 11 
 Command ===> _____________________________________________________ Scroll CSR  
                                                                                
 Cmd Con ( Field Name                          Op  Value                       )
     <-> - <---+----1----+----2----+----3----> <-> <---+----1----+----2----+-- -
 *** ****  Top of data  ****                                                    
           1 REDEFINES-LAYOUT                                                   
     AND    2 REDEF-TYPE                       =   A                            
     AND    2 DATA-A                                                            
     AND     3 DATA-A1                                                          
     AND     3 DATA-A2                                                          
     AND    2 DATA-B                                                            
     AND     3 DATA-B1                                                          
     AND     3 DATA-B2                                                          
     AND    2 DATA-C                                                            
     AND     3 DATA-C1                                                          
     AND     3 DATA-C2                                                          
 *** ****  End of data  **** 
                                                   

Enter the expression = A as shown in the sample panel for DATA-A definition. Note that the operator defaults to "=" if left blank.

Press F3.

  Process   Options   Help                                                      
 ───────────────────────────────────────────────────────────────────────────────
 Z Data Tools   REDEFINES Criteria: DATA-B                         Line 1 of 11 
 Command ===> _____________________________________________________ Scroll CSR  
                                                                                
 Cmd Con ( Field Name                          Op  Value                       )
     <-> - <---+----1----+----2----+----3----> <-> <---+----1----+----2----+-- -
 *** ****  Top of data  ****                                                    
           1 REDEFINES-LAYOUT                                                   
     AND    2 REDEF-TYPE                       =   B                            
     AND    2 DATA-A                                                            
     AND     3 DATA-A1                                                          
     AND     3 DATA-A2                                                          
     AND    2 DATA-B                                                            
     AND     3 DATA-B1                                                          
     AND     3 DATA-B2                                                          
     AND    2 DATA-C                                                            
     AND     3 DATA-C1                                                          
     AND     3 DATA-C2                                                          
 *** ****  End of data  ****                                                    

Enter the expression = B as shown in the sample panel for DATA-B definition and then press F3.

  Process   Options   Help                                                      
 ───────────────────────────────────────────────────────────────────────────────
 Z Data Tools   REDEFINES Criteria: DATA-C                         Line 1 of 11 
 Command ===> _____________________________________________________ Scroll CSR  
                                                                                
 Cmd Con ( Field Name                          Op  Value                       )
     <-> - <---+----1----+----2----+----3----> <-> <---+----1----+----2----+-- -
 *** ****  Top of data  ****                                                    
           1 REDEFINES-LAYOUT                                                   
     AND    2 REDEF-TYPE                       =   C                            
     AND    2 DATA-A                                                            
     AND     3 DATA-A1                                                          
     AND     3 DATA-A2                                                          
     AND    2 DATA-B                                                            
     AND     3 DATA-B1                                                          
     AND     3 DATA-B2                                                          
     AND    2 DATA-C                                                            
     AND     3 DATA-C1                                                          
     AND     3 DATA-C2                                                          
 *** ****  End of data  ****                                                    

Enter the expression = C as shown in the sample panel for DATA-C definition and then press F3.

  Process   Options   Help                                                      
 ───────────────────────────────────────────────────────────────────────────────
 Z Data Tools                 Field Selection/Edit                 Line 1 of 11 
 Command ===> _____________________________________________________ Scroll CSR  
                                                                                
 ----------- Criteria - Enter 1 or 2 to specify expression by field ----------- 
 1 Id :                                                                        + 
 2 Sel:                                                                        + 
 Offset      0                                                      CCSID _____ 
 Cmd Seq SHE Ref Field Name                           Picture  Type Start Length
                 ****  Top of data  ****                                        
 ___ ___       1 1 REDEFINES-LAYOUT                             AN      1      5
 ___ ___       2  2 REDEF-TYPE                        X         AN      1      1
 ___ ___       3  2 DATA-A                                      AN      2      4
 ___ ___       4   3 DATA-A1                          XX        AN      2      2
 ___ ___       5   3 DATA-A2                          XX        AN      4      2
 ___ ___       6  2 DATA-B REDEFINES DATA-A                     AN      2      4
 ___ ___       7   3 DATA-B1                          99        ZD      2      2
 ___ ___       8   3 DATA-B2                          99        ZD      4      2
 ___ ___       9  2 DATA-C REDEFINES DATA-A                     AN      2      4
 ___ ___      10   3 DATA-C1                          S9(4)     BI      2      2
 ___ ___      11   3 DATA-C2                          S9(4)     BI      4      2
                 ****  End of data  ****                                        
                                                                                
Note: The fields that have redefines criteria (fields 3, 6, and 9) will have their reference number highlighted in red on the Field Selection/Edit panel.