Adding or changing table information for loading data

Use the Add Table window to add tables that are used as targets of load processing. Use the Change Table window to modify information about tables defined as targets load processing.

To add or change target table information for the LOAD processing:

1. Type the table owner's name, or authorization identifier.
   
   
2. Type the table name. The table must have already been defined and listed in the catalog table.
   
   
3. Select the Condition when records are to be loaded check box to set up criteria for when records are loaded. 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 three ways of describing the conditions for the loading:
   • Specify the SQL/DS table radio button to use an SQL/DS table and then type the table name in the field. SQL/DS is valid only when the FORMAT SQL/DS option was selected from the Options page of the notebook. The table name uses the SQL/DS name of a table that has been unloaded onto the SQL/DS unload data set.

   • Specify the Selection criterion using field name radio button to use a field name in the criteria. The field selection criterion describes a field or column name. For example, if you wanted to set

     WHEN DEPTNO = 'D11'

     as the condition statement, type DEPTNO in the field name field.

   • In the Selection criterion using column positions radio buttons, instead of basing your WHEN clause on a column name, you can base your WHEN clause on position number. For example, to describe WHEN (33:34) = X'FFFF', the Start column field would have the value 33 and the End column field would have the value 34. 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'

4. Click OK to add the Target Table description.