ODBC Table Select - Fields

 

ODBC Table Select

Job Name

This field displays the job name, and can only be viewed.

 

ODBC Table

Select the table into which you want to export data. All tables defined in the ODBC table source appear in this drop-down box.

 

ODBC Fields

This list box displays all data fields defined for the selected ODBC table. Double-click a field line to toggle the key flag from No to Yes and designate the data field as a key field. Flagging a data field as a key field allows the exported records to be updated to any existing records.

Key fields are used to match exporting records with any existing records. If a match is found, the export data is updated to the existing record. If no match is found, the export data is inserted (added) to the database. If no field is designated as a key field, the export data is always inserted (added) to the database.