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. If you are loading data into a partitioned table space, you can use the Part Clause page to specify how to load data into a specific partition.
      
      
   5. Click OK to save your changes and close the window.

Loading data into a specific partition

These steps are part of the larger task of loading data into a table space. When you complete the steps for loading data into a specific partition, return to the main task.

To load data into a specific partition:

1. Select the Load data into a specific partition check box.
   
   
2. Click the up or down arrows in the Partition field to specify the partition number.
   
   
3. Select the Entire partition is preformatted check box if you want to preformat the remaining pages up to the high allocated RBA in the table space and index spaces associated with the table. The preformatting happens after the data is loaded and the indexes are built.
   
   
4. Select the Specify RESUME option at partition level check box and then specify YES or NO to determine whether records are to be loaded into an empty or none-empty table space.
   
   
5. Select the Reset partition to empty before load check box have the newly loaded rows replace all existing rows. If you decide to use the reset option, select the Retain the current compression dictionary check box to keep the compression dictionary, KEEPDICTIONARY. If you select the check box, the load utility does not build a new dictionary.
   
   
6. If you click the reset option, complete the appropriate data set information to hold the data.
   
   
   • Specify 2 copy data sets, primary and backup data sets. These data sets contain image copy data sets. The default is SYSCOPY for the primary copy. A full image copy data set is created for the table specified when load executes. The table space for which an image copy is produced is not placed in COPY pending status.
   
   
   
   • Specify 2 copy data sets at the recovery site, primary and backup data sets. These data sets contain image copy data sets
   .