Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited supportBMC 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).

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*