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