Key Field Tab, Input Side of Map

Edit online

The following list describes the properties of the SQL Input Record dialog box Key Field tab (on the Input side of the map only):

None Use constant Use codelist Use Field

Type of information that the translator uses to match this record.

Select Use constant or Use codelist to activate the middle section of the dialog box.
Select Use Field to activate the lower section of the dialog box.

Match record when key does not match

Translator must match the record if the Key Field does not have the value specified.

Key Field

Field that the translator checks to verify whether the key field does or does not (depending on which you specify) match the constant, code list, or field value or values.

Note: Key fields are intended to be used with string fields only. If you use a key field on a numeric field, the result is not guaranteed.

Constants Edit

List of defined constants. The translator matches the selected constant against the key field. To add or change a constant, click Edit to access the Map Constants dialog box.

Code Lists Edit

List of defined code lists. The translator matches the selected code list against the key field. To add or change a code list, click Edit to access the Code Lists dialog box.

Key Field 1

First key field and contains all the active fields from this record.

Note: Key fields are intended to be used with string fields only. If you use a key field on a numeric field, the result is not guaranteed.

Use Field 1

Specifies that the first key field must match the value in the field from an earlier record and contains all the active fields from the preceding records (not including this record).

Key Field 2

Second key field, if necessary, and contains all the active fields from this record.

Note: Key fields are intended to be used with string fields only. If you use a key field on a numeric field, the result is not guaranteed.

Use Field 2

Specifies that the second key field must match the value in the field from an earlier record and contains all the active fields from the preceding records (not including this record).

Key Field 3

Third key field, if necessary, and contains all the active fields from this record.

Note: Key fields are intended to be used with string fields only. If you use a key field on a numeric field, the result is not guaranteed.

Use Field 3

Specifies that the third key field must match the value in the field from an earlier record and contains all the active fields from the preceding records (not including this record).