Utility Functions › Data Set Reformat › Data Set Reformat Parm

Data Set Reformat Parm

The Reformat Parm screen is used to build and update a member in the Reformat Control Parameter data set. Specify the field-to-field translations that are to occur in the reformat process by defining which fields in the "FROM" record are to be copied to the "TO" record. In the process of copying field values, reformatting occurs for fields whose position, length, field format, or number of decimal places is different between the "FROM" and "TO" records.

CA File Master Plus -- Reformat ---- MYDS.INST.REFORMAT(CUSTVND4)
  COMMAND ===>                                                  SCROLL ===> CSR 
                                                                                
FROM Record ------------ CUSTVNDR of ABC.PROD.COPYLIB --------------------------
Num Field Name                    Pos    Format                      Row 1 of 28
    1 CV-CUSTOMER-VENDOR-RECORD       1      163                               
    2   CV-RECORD-TYPE-CODE           1 C      1                               
    3   CV-CUSTOMER-DATA              2      162                               
    4     CV-CUSTOMER-NUM             2 N      9                               
    5     CV-CUSTOMER-TYPE-CODE      11 C      2                              
    6     CV-ACCT-OPENED-DATE        13 N      6                              
    7     CV-DOB                     19 N      6                               
    8     CV-1ST-TRANSACTION-DATE    25 N      6                               
    9     CV-CURRENT-BAL             31 P    9.2                                
   10     CV-ORIG-BAL                37 P    9.2                                
   11     CV-PAYMENT-AMT             43 P    9.2                                
   12     CV-PAYMENT-PERIOD          49 N      2                               
   13     CV-NAME                    51 C     25                               
   14     CV-ADDR-1                  76 C     30                               
   15     CV-ADDR-2                 106 C     30                               
   16     CV-CITY                   136 C     20                               
   17     CV-STATE                  156 C      2                               
   18     CV-ZIP-CODE               158 P      9                                
 TO Record   ------------ CUSTVND2 of ABC.PROD.COPYLIB -------------------------
 Num Field Name                    Pos    Format  Reformat           Row 1 of 28
    1 CV-CUSTOMER-VENDOR-RECORD        1      163                              
    2   CV-RECORD-TYPE-CODE            1 C      1 CV-RECORD-TYPE-CODE           
    3   CV-CUSTOMER-DATA               2      162                              
    4     CV-CUSTOMER-NUM              2 P   11.2 CV-CUSTOMER-NUM               
    5     CV-CUSTOMER-TYPE-CODE        9 C      2 CV-CUSTOMER-TYPE-CODE         
    6     CV-ACCT-OPENED-DATE         11 N      6 CV-ACCT-OPENED-DATE           
    7     CV-DOB                      17 N      8 CV-DOB                        
    8     CV-1ST-TRANSACTION-DATE     25 N      6 CV-1ST-TRANSACTION-DATE       
    9     CV-CURRENT-BAL              31 P    9.2 CV-CURRENT-BAL                
   10     CV-ORIG-BAL                 37 P    9.2 CV-ORIG-BAL                   
   11     CV-PAYMENT-AMT              43 P    9.2 CV-PAYMENT-AMT                
   12     CV-PAYMENT-PERIOD           49 N      2 CV-PAYMENT-PERIOD             
   13     CV-NAME                     51 C     25 CV-NAME                       
   14     CV-ADDR-1                   76 C     30 CV-ADDR-1                     
   15     CV-ADDR-2                  106 C     30 CV-ADDR-2                     
   16     CV-CITY                    136 C     20 CV-CITY                       
   17     CV-STATE                   156 C      2 CV-STATE                      
   18     CV-ZIP-CODE                158 P      9 CV-ZIP-CODE                   
                                                                               

The DSN and member name of the parameter member being created or updated appears in the top right corner of the screen.

The top section of the screen, after the heading, presents the record layout of the FROM Record. The bottom section of the screen presents the TO Record layout and contains a field on each line for typing the Field Name of the FROM Record to be copied to the TO Record. For new parameter members, the Reformat Control Parm defaults to copy all non-group fields that have the same Field Name in the "FROM" and "TO" records.

For each field in the "FROM" and "TO" records, the following screen columns are presented: