Data translator

This feature allows translating data values in one or more fields based on a translate table containing lookup and/or result values. The Translator function accesses the translate table based on values from the fields specified on the formatted panel. When the corresponding row is determined, it returns the result values and uses them to replace the specified output field value.

Specify the following information to create formatted data translation criteria:

• You must specify the data set name of an existing translation table file (i.e. DASAMP.AREACODE.CONVERT) in the TABLE DATASET field.

  Enter S (Binary search Field), K (Key search field), D (Direct row pointer search field), H (Hash to a key search field), R (Result field), SR (Binary search and Result field), KR (Key search and Result field), DR (Direct row pointer search and Result field), HR (Hash to a key search and Result field), U (Unique search field), UR (Unique search and result field), or FM (Field mask) in the Relational Operator (RO) field to the right of the field you want to create formatted data translator criteria.

• File-AID/Data Solutions displays a Parameter pop-up window based on the relational operator (RO) that you specified. Enter the appropriate parameters.