Field In an Output Record (Input or Output Side of Map)

Edit online

About this task

If the field is located in an output record on the input or output side of the map, the field represents a column that the translator updates or inserts, or a key column. You specify the name of the column and indicate whether it is a key. Sterling B2B Integrator Map Editor uses key columns automatically to create a WHERE clause for UPDATE and DELETE statements.

Note: If the field is contained in an output record, the validation information is set from the column to which it is mapped.

To verify whether a link is valid when using SQL in an output record:

Procedure

  1. Verify all fields that are linked are of same data type.
  2. Verify all columns in the table that defined as not null are populated with data in the map.
  3. Verify that, for any linked fields, the input field length is not greater than the output field length.
  4. Verify that the data to be inserted does not violate any unique key or any other constraints on the tables.