Replacing data without allowing concurrent access
The following example illustrates a typical LOAD REPLACE in which you load new data into a table space that has been deleted and redefined. The job defaults to SHRLEVEL NONE, causing
BMC AMI Load
to stop the table space before loading the data.
//SYSREC DD DISP=SHR,DSN=USER.DATA
//SYSIN DD *
LOAD DATA REPLACE INDDN SYSREC
INTO TABLE NGT.TABLE1
(ID POSITION(2),
MESSAGE POSITION(*) CHAR(34) NULLIF(1:1) = '?',
LANGUAGE POSITION(*) CHAR(10) DEFAULTIF(1:1) = '?')
//SYSIN DD *
LOAD DATA REPLACE INDDN SYSREC
INTO TABLE NGT.TABLE1
(ID POSITION(2),
MESSAGE POSITION(*) CHAR(34) NULLIF(1:1) = '?',
LANGUAGE POSITION(*) CHAR(10) DEFAULTIF(1:1) = '?')
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*