Managing 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 translator modifies and whether to INSERT, UPDATE, or DELETE.
The fields contained within an output record represent the columns the translator 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.
At least one field (column) in an Output Record must be defined as a TableKey.
At least one field (column) in an Output Record must be defined as a TableKey.
For more information about properties, see Sterling B2B Integrator Map Editor Properties.
For more information, see Using the Auto Get Next Cursor Operation.