Changing a target table

To make changes to the target table:

1. Optional: To change the table owner or table name: Type the name or owner that you want, or click to select a name from the List window.

2. Optional: To specify when to load the table:

   1. Select the Condition when records are to be loaded check box.

   2. Select a radio button to indicate selection criteria of either field name or column positions:
      • If you select Selection criterion using field name, type the name of a column in the table. For example type DEPTNO as the field name if the WHEN condition is WHEN DEPTNO = "D11".
      • If you select Selection criterion using column positions, indicate where the field is in the assembled load record by typing the starting and ending column numbers of the field. Column locations can be represented by:
        • An integer n, or actual column number
        • *, to indicate one column after the end of the previous field
        • * + integer n, to indicate n columns after the location indicated by *.

   3. Select a radio button to indicate whether the string in the selection is Hexadecimal, Character, or Graphic and type the constant for the string you selected.

      If you selected a hexadecimal string, the constant is X'nnnn".

      If you selected a character string, the constant is any fixed length character string.

      If you selected a graphic string, the constant is the number of double-byte characters in the string. The length of the field is twice the number of double-byte characters. For example, '***' represents 3 double-byte characters.

   4. Click OK to save your changes and close the window.