Setting up column definitions

You set up column definitions for read operations and write operations in a similar way. You can also customize the columns grid, save column definitions for later use, and load predefined column definitions from the repository.

Procedure

  1. On the job design canvas, double-click the Db2 connector icon.
  2. Select either the Output tab or the Input tab depending on the type of link that you want to edit.
  3. On the Columns tab, modify the columns grid to specify the metadata that you want to define.
    1. Right-click within the grid, and select Properties from the menu.
    2. In the Grid properties window, select the properties that you want to display and the order that you want them to be displayed. Then, click OK.
  4. Enter column definitions for the table by using one of the following methods:
    Option Description
    Method 1
    1. In the Column name column, double-click inside the appropriate cell and type a column name.
    2. For each cell in the row, double-click inside the cell and select the options that you want.
    3. In the Description column, double-click inside the appropriate cell and type a description.
    Method 2
    1. Right-click within the grid, and select Edit row from the menu.
    2. In the Edit column metadata window, enter the column metadata.
  5. To share metadata between several columns, select the columns that you want to share metadata.
    1. Right-click and select Propagate values.
    2. In the Propagate column values window, select the properties that you want the selected columns to share.
  6. To save the column definitions as a table definition in the repository, click Save.
    1. Enter the appropriate information in the Save Table Definition window, and then click OK.
    2. In the Save Table Definition As window, select the folder where you want to save the table definition, and then click Save.
  7. To load column definitions from the repository, click Load.
    1. In the Table Definitions window, select the table definition that you want to load, and then click OK.
    2. In the Select Columns window, use the arrow buttons to move columns from the Available columns list to the Selected columns list. Click OK.