Setting up column definitions (Java Integration stage in DataStage®)

You can set up column definitions for a link and also customize the columns grid, save column definitions for later use, and load predefined column definitions from the repository.

1. On the job design canvas, double-click the Java Integration stage icon.
2. Select the Input tab and select the input link that you want to edit from the Input name (upstream stage) drop down list or select the Output tab and select the output link that you want to edit from the Output name (downstream stage) drop down list.
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	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.

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.