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. Select the push button for a search list of table owners.

2. Type the table name. Select the push button for a search list of table names. 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. For partition table spaces only, you can select the PART Clause notebook page to describe how data should be loaded for a particular partition.

5. Click OK to add the Target Table description.

Adding Partition information in the Target Table

Use the PART Clause notebook page to define how data is loaded into a specific partition.

1. Select the Load data into a specific partition check box to load data into a partition. If this check box is not selected, you cannot load data into a partition.

2. Specify the partition number that this description is for.

3. Select the Entire partition is preformatted check box to use preformatting. Preformat specifies that the remaining pages are preformatted up to the high allocated RBA in the partition and its corresponding partitioning index space. Preformatting occurs after the data has been loaded and the indexes are built.

4. Select the RESUME check box to determine whether records are to be loaded into an empty or non-empty partition. This is NOT valid if you specified a RESUME option on the Options page of this notebook. You can specify RESUME YES, or RESUME NO.

5. Select the Reset partition to empty before load check box to replace only the contents of the specified partition number, rather than the entire table space. If you specified the Reset option on the Options page of this notebook, this is NOT valid. If you do choose the partition reset option, then you can decide to keep the current dictionary and use it for compressing the input data. The dictionary option is only valid if a dictionary exists and the partition being loaded has COMPRESS YES as an attribute.

6. Select the REUSE check box to use non-empty data sets when loading data. You must have already defined these data sets with the VSAM REUSE option to do this. If you have not, or if you do not specify the REUSE check box, then data sets that are used with loading data must be empty.

7. Optional: You can specify 2 copy data sets, primary and backup data sets, but only with the REPLACE option set from the Options page of this notebook. 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 partition specified when LOAD executes. The partition for which an image copy is produced is not placed in COPY pending status.

8. Optional: You can specify 2 copy data sets at the recovery site, primary and backup data sets, but only with the REPLACE option set from the Options page of this notebook. These data sets contain image copy data sets.