Jump to main content
HCL Logo Product Documentation
Customer Support Software Academy Community Forums
HCL Z Data Tools User’s Guide and Reference for Db2 Data Version 1.1.2
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with ZDT/Db2
  • ZDT/Db2 reference
  • Messages
  • Notices
  1. Home
  2. Working with ZDT/Db2
  3. Working with templates
  4. Mapping data
  5. Where you can map data
  • Working with ZDT/Db2
    • ZDT/Db2 overview
    • System requirements for Z Data Tools for Db2®
    • Getting started with ZDT/Db2
    • Working with templates
      • Associating a template with a Db2® object
      • Information stored in a template
      • Using templates with non-Db2 data
      • Editing a template
      • Selecting rows
      • Manipulating columns
      • Specifying scrambling options
      • Mapping data
        • Where you can map data
        • Letting ZDT/Db2 do the mapping
        • Specifying your own mapping
        • Column mapping rules
      • Creating a copybook from a Z Data Tools/Db2 Template

        ZDT/Db2 provides a sample REXX exec (HFM2CPYB) that you can use to create a PL/I or COBOL copybook from a Z Data Tools/Db2 template.

    • Viewing and changing Db2® data

      To view the contents of a Db2® table or view, use the ZDT/Db2 View Utility (option 1), the ZDT/Db2 Edit Utility (option 2), or the ZDT/Db2 Browse Utility (option B).

    • Creating and dropping Db2® objects
    • Populating a Db2® table with data
    • Copying data
    • Working with lists of Db2® objects
    • Printing
    • Managing Db2® privileges
    • Generating batch JCL for Db2® utility jobs
    • Working with SQL statements
    • Using ZDT/Db2 functions in batch jobs

      You can perform ZDT/Db2 functions that can be executed in batch jobs.

    • Interfacing with Db2® Interactive

Where you can map data

You can use templates to map data with the following ZDT/Db2 functions:
  • Copy (option 3.3)
  • Import (option 3.6)
  • Export (option 3.7)
  • Utilities (option 3.9)

Related tasks

  • Copying data from one Db2 object to another
  • Copying data from a VSAM or QSAM file
  • Copying data to a VSAM or QSAM file
  • LOAD utility

Rate this topic


  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences