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.

Unloading by using a table lookup

It is sometimes useful to select the rows to unload by determining if the rows exist in another table (for example, if you have a production application that identifies rows to be unloaded over the weekend for later transfer to a non-Db2 application).

Information
Example
//SYSIN DD *
         UNLOAD DATA FORMAT(DSNTIAUL) UNLOADDN(SYSREC)
         SELECT *
         FROM BMC.PRODUCTION_TBL
         WHERE RECID IN (SELECT RECID FROM ROWS2UNLD)

Related topic

FORMAT DSNTIAUL 

 

 

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

BMC AMI Unload for Db2 12.1