Input Records
An input record contains a logical group of fields that are suitable to be mapped to the output format.
For example:
The input side of the map is ODBC and the output file format is Positional, and you need to generate a record using information from two separate queries. You can create an ODBC input record that contains fields which obtain data from the appropriate columns of both queries. Then you can link those fields directly to the corresponding positional fields.
Key field functionality
Input records support the standard Sterling Gentran:Server® key field constant and code list functionality. Additionally, the system provides you with the ability to match against fields that appear earlier in the map. If you choose to match against an earlier mapped field, you are allowed up to three key fields.
This additional key field functionality is very useful when you are mapping from a join of master-detail records to an equivalent hierarchy, because this allows the translator to detect when the keys in the detail level no longer match the keys in the master level.
Auto get next cursor operation
If the fields of an input record all belong to the same query, you can specify that the system automatically perform an auto get next cursor operation as the input record loops.