|Contents:||Main||Chapter||See Also:||Getting Started Manual||Programmer Manual|
Mapping information identifies the relationship between the data in the source file and the data in the destination file. When you create your EXTRACT template, you will enter the name of the field in the source file and identify its intended location in the destination file. You will need to ensure that the Data Type of the field in the destination file is compatible with the Data Type of the extract field. The compatibility of the Data Types is validated when the fields are specified during template creation.
The following table recommends the Data Type to use, depending on the Data Type of the extract field:
|Data Type of Extract Field||Data Type of Destination Field|
|DATE/TIME||1) DATE/TIME, internal form of data is moved.
2) FREE TEXT, external form of data is moved.
|NUMERIC||NUMERIC or FREE TEXT.|
|SET OF CODES||1) FREE TEXT, if external form of the SET OF CODES is moved.
2) SET OF CODES, if internal form of the SET OF CODES is moved. User must make sure the SET OF CODES fields are identical in both the source file and the destination file data dictionaries.
|FREE TEXT||FREE TEXT.|
|COMPUTED||FREE TEXT, DATE/TIME, or NUMERIC.|
|POINTER TO A FILE||1) NUMERIC, if internal form of data is moved.
2) Non-pointer field type (FREE TEXT, NUMERIC, or DATE/TIME), if external form of data is moved.
|VARIABLE-POINTER||1) Non-pointer field type, if external form of data is moved; (if
the .01 fields of the pointed-to files have different Data Types, Data Type of
destination field should be FREE TEXT).
2) FREE TEXT, if internal form of data is moved.
Here are additional guidelines that you must follow while creating your destination file:
Reviewed/Updated: March 4, 2007