Replacing some partitions, adding data to some partitions, and leaving remaining partitions available
//SYSREC DD DISP=SHR,DSN=USER.DATA
//SYSIN DD *
LOAD DATA RESUME YES INDDN SYSREC
INTO TABLE NGT.TABLE1 PARTS 2,4,6 REPLACE
(fieldSpecification)
INTO TABLE NGT.TABLE1 PARTS 1,3,5 RESUME YES
(fieldSpecification)
//SYSIN DD *
LOAD DATA RESUME YES INDDN SYSREC
INTO TABLE NGT.TABLE1 PARTS 2,4,6 REPLACE
(fieldSpecification)
INTO TABLE NGT.TABLE1 PARTS 1,3,5 RESUME YES
(fieldSpecification)
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*