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

Related topics

INFILE

UNLOAD-syntax-diagrams

//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



 

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