Jump to main content
IBM Logo Product Documentation
  • Products
  • Support
IBM File Manager for z/OS® User’s Guide and Reference for Db2 Data Version 14.1.19
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with FM/Db2
  • FM/Db2 reference
  • Messages
  • Support resources
  • Notices
  1. Home
  2. Working with FM/Db2
  3. Working with templates
  4. Mapping data
  5. Where you can map data
  • Working with FM/Db2
    • FM/Db2 overview
    • System requirements for File Manager for Db2®
    • Getting started with FM/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 FM/Db2 do the mapping
        • Specifying your own mapping
        • Column mapping rules
      • Creating a copybook from a File Manager/Db2 Template

        FM/Db2 provides a sample REXX exec (FMN2CPYB) that you can use to create a PL/I or COBOL copybook from a File Manager/Db2 template.

    • Viewing and changing Db2® data

      To view the contents of a Db2® table or view, use the FM/Db2 View Utility (option 1), the FM/Db2 Edit Utility (option 2), or the FM/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 FM/Db2 functions in batch jobs

      You can perform FM/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 FM/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