Adding or changing field information for target tables

Use the Add Field window to add field specifications to target tables that are used in load processing. Use the Change Field window to modify field specifications of tables defined as target tables in load processing.

To add or change a field specification:

1. In the Field name field type the name of a field. If the field is to be loaded, the field name must be the name of a column in the selected table.

2. Optional: In the Start column field and the End column field, type a starting and ending column number. This tells where a field is in the assembled load record. Start and end are the locations of the first and last columns of the field. There are three acceptable ways of indicating column locations:
   • integer, or an actual column number

   • "*", which means one column after the end of the previous field

   • "*" + integer, meaning some number of columns after the location specified by "*"

3. In the Data type field, specify a data type of the field from the list. Depending on the data type, you might have to indicate length or scale in the Datatype characteristics area. Except for graphic fields, length is the length in bytes of the input field.

4. Optional: Specify that you want either a NULL value loaded or the default value loaded depending on the conditions you select. This appears as the WHEN clause in the output. If there is no WHEN clause, and if UNLOAD is not used in the FORMAT part of the LOAD options page, then all records in the input data set are loaded into the specified tables or partitions. If the WHEN clause is to be used, you have two ways of describing the conditions for the loading:
   • You can select to use a field name. The field name is the name of a field described by the field specification. For example, if:

     WHEN DEPTNO = 'D11'

     is the condition you want to use, DEPTNO is the field name you should type.

   • Instead of basing your WHEN clause on a column name, you can base your WHEN clause on position number, as in

     WHEN (33:34) = X'FFFF'

     Start and end column numbers are the column numbers in the assembled load record. The two numbers tell the starting and ending columns of a selection field in the load record. If you do not specify an ending column position, the field is assumed to have the same length as the constant.

   For either the field criterion or the column position criterion, you can use a hexadecimal string, a character string, or a graphic string. Select one of the radio buttons for the string type and then define the constant. For example, if you selected a graphic string, you might type the constant as

   G'<**>'

   where "<" is the shift-out character, "*" is the double-byte character, and ">" is the shift-in character. If you chose a hexadecimal string, your constant might look like

   X'FFFF'

5. Click the OK push button to commit your additions or changes to the table space list.