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.

Important

For the assumptions made in this example, see Assumptions made in the syntax examples.

Related topics

SYSREC

SYSIN 


 //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) = '?')


 

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