Output Records

An output record represents an update, insert, or delete SQL statement, and contains database output fields. You specify the name of the table the system modifies and whether to insert, update, or delete.

The fields contained within an output record represent the columns the system is updating or inserting and the key to the affected row or rows. Output records may be created on both the input and output sides of a map.

Note: The output record cannot be referenced by standard rules or links.
Important: Any ODBC map that uses an ODBC Output Record and is translating against a Microsoft database (Access or SQL Server) must turn on (activate) the "Use ANSI Quoted Identifiers" option in the ODBC DSN configuration.

Key field functionality

Output 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 output record all belong to the same query, you can specify that the system automatically perform an auto get next cursor operation as the output record loops.

Note: You specify the "Automatically get next row from Statement record" option on the Looping tab of the ODBC Output Record Properties dialog box.