Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Unload for Db2 13.1.

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"

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  

Related topics

Examples-of-BMC-AMI-Unload-jobs

Command-and-syntax-reference-for-BMC-AMI-Unload

 

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

BMC AMI Unload for Db2 12.1