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 from a full image copy data set

You can use the INFILE option to unload from a full image copy data set that is registered in the Db2 catalog. 

Specifying INFILE IMAGECOPY unloads the most recent full image copy data set that BMC AMI Unload finds in the SYSIBM.SYSCOPY table or, for a cabinet copy, the BMCXCOPY table. The following example also illustrates the following functions:

  • Overriding the default Db2 date and timestamp format
  • Unloading from a subset of a copy
  • Sorting the data from the copy
//SYSIN    DD   *
 UNLOAD INFILE IMAGECOPY
        TSFMT('MM.DD.YY/HH:MM:SS.NN')
        DATEFMT('MM.DD.YY')
        PART 3
        SELECT *
           FROM BMC.EMPLS WHERE SSN > '200000000'
             ORDER BY HIRE_DATE DESC, EMPL_LNAME

Related topics

INFILE

UNLOAD-syntax-diagrams

 

 

 

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