Home
Working with ZDT/Db2
Using ZDT/Db2 functions in batch jobs
You can perform ZDT/Db2 functions that can be executed in batch jobs.

Working with ZDT/Db2
- ZDT/Db2 overview
- System requirements for Z Data Tools for Db2®
- Getting started with ZDT/Db2
- Working with templates
- 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.
  - JCL syntax for Z Data Tools/Db2 batch jobs
    To use a Z Data Tools/Db2 function in a batch job, include the following statement: //stepname EXEC PGM=HFMDB2,PARM=('SSID=sysid,SQID=sqlid')"
  - Using Z Data Tools/Db2 edit models
    This topic explains how to use edit models to create batch JCL to access Z Data Tools/Db2 functions.
  - Edit model example: JCL that calls the DBP function
    This example shows how to use edit models to generate a batch job to print a Db2 table using the DBP function.
- Interfacing with Db2® Interactive

Using ZDT/Db2 functions in batch jobs

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

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

Edit models are provided that insert predefined statements and instructions for a selected Z Data Tools/Db2 function or REXX external function.