Using tdfmaker to define update keys

To insert the data produced by a mapping operation as new rows into a database table or to update only specific columns, you need to define the key columns and the columns to update. If you have access to your DB2® database through ODBC, use the Database Interface Designer to designate certain columns in a database as key columns in a table. For information about defining update key columns using the Database Interface Designer, see the Database Interface Designer documentation. If you do not have ODBC connectivity to your DB2 database, use the tdfmaker installed on your z/OS® system during the installation of the adapters for DB2.

When you run tdfmaker on your z/OS system, tdfmaker interrogates all of the tables in the library or each specified table name. It derives a listing of the column names defined in the tables and then outputs this information to a table definition file (.tdf).

After tdfmaker completes, transfer the table definition file in TEXT mode to your development PC, specifying the file name extension as .tdf. Then use the Database Interface Designer to process the .tdf so that you can specify update keys. Because you do not have ODBC connectivity when using the Database Interface Designer, when you select Set Update Keys from the Database menu, you are prompted for the name of the .tdf.