Changing a field

Use the Change field window to change the values of a field named on the Target Tables page of the Load Table Space notebook. You can also specify whether the field is to be loaded with null characters or default values.

To change a field:

  1. Type the field name, start column, and end column in the appropriate fields.

  2. Select the data type from the Data type list, and type the datatype characteristics for the type of data that you selected.
  3. Optional: To specify whether the column should be loaded with null or default values:
    1. Select the checkbox to decide if a NULL value or a default value should be loaded based on certain conditions.
    2. Select either the Null or the Default radio button.
    3. Select a radio button to indicate selection criteria of either field name or column positions:
      • If you select Using field name, type the name of a column in the table. For example type DDEPTNO as the field name if the WHEN condition is WHEN DEPTNO = D11.
      • If you select 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 *
    4. Select either the Hexadecimal string, Character string, or Graphic string , radio button and type the values for the selection you choose.

      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.