0 / 0
Setting up column definitions (Java Integration stage in DataStage®)
Last updated: Nov 07, 2024
Setting up column definitions (Java Integration stage in DataStage)

You can set up column definitions for a link and 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 Java Integration stage icon.
  2. Select the Input tab and choose the input link that you want to edit from the Input name (upstream stage) drop down list, or select the Output tab and choose 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
    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. Navigate to 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. Select the columns and click the Edit selected rows to bulk edit the properties.
    2. In the Propagate column values window, select the properties that you want the selected columns to share.
    You can import or export your columns as data definitions. For more information, see Importing data definitions and Creating data definitions.