Skip to Content

Unload producing a custom load statement

This unload statement produces a custom load statement to include the keywords RESUME NO REPLACE and an alternative table name ANOTHER.TABLE. The load statement starts with the following syntax:

LOAD DATA INDDN(SYSREC)
  RESUME NO REPLACE
 INTO TABLE "ANOTHER"."TABLE"

Related topics

Examples-of-BMC-AMI-Unload-jobs

BMC-AMI-Unload-command-and-syntax-reference


Information
Example
//UNLOAD EXEC PGM=NGTUTIL,PARM='ssid,,NORESTART'
//*
//UTPRINT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//OBJREPRT DD SYSOUT=*
//*
//SYSCNTL DD SYSOUT=*
//SYSIN DD *
 OUTPUT SYSREC DSNAME hlq.OUTDATA.&TS..P&PART..T&TIME
 UNLOAD
 CNTLCARDS DB2LOAD ' RESUME NO REPLACE'
   SELECT *
     INTO NAME ANOTHER.TABLE
     FROM creator.table  

 

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

BMC AMI Unload for Db2 13.1