Data Transformation Engine Database Interface Designer Reference Guide

Chapter 6 - Updating Database Tables Defining Key and Update Columns
Database Interface Designer Reference Guide
102
Defining Key and Update Columns
To update a table from a map, use the Database Interface Designer to specify the
columns in a table to be used as key columns and to specifically specify the
columns that will be updated.
To designate columns as key columns or columns to update
1 In the Navigator, select the database containing the table for which you want
to set update keys.
2 From the Database menu, choose Set Update Keys.
The Set Table Update Key Columns dialog box appears.
3 From the Table name list, select the table containing the columns to be
updated.
The columns in the table are displayed in the Columns list.
4 To set a column as a key column, select it from the Columns list and click the
button associated with the Key columns list.
The selected column moves to the Key columns list.