-LOAD LOAD (IBM utility)

The -LOAD command invokes the Db2 LOAD utility to load data from an unloaded data set.

The load statement includes the unload data set identifier for the -UNLD command. This command, shown in the following figure, and its parameters are passed through to Db2.

Related topic

Worklist-commands

When restarting after a failed LOAD RESUME, the product executes an SQL DELETE statement before the LOAD to clean up any data in the table that the failed LOAD left.

The new column definitions correspond to the -UNLD command lines. The column definitions are ordered by the new column sequence and refer to the new column names. The product omits new columns with NULL YES or DEFAULT YES.

-LOAD command

-LOAD 000004
 LOAD DATA
 INDDN SYSR0001
 WORKDDN SYSUT001
 ERRDDN SYSE0001
 MAPDDN SYSM0001
 COPYDDN (C0001,D0001)
 RESUME NO
 REPLACE
 EBCIDIC
 SORTDEVT
 INTO TABLE WZU.WZT01_D5122S1

For more information, see the IBM DB2 Utility Guide and Reference documentation.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*