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

Working with FM/Db2
- FM/Db2 overview
- System requirements for File Manager for Db2®
- Getting started with FM/Db2
- Working with templates
- 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.
  - JCL syntax for File Manager/Db2 batch jobs
    To use a File Manager/Db2 function in a batch job, include the following statement: //stepname EXEC PGM=FMNDB2,PARM=('SSID=sysid,SQID=sqlid')"
  - Using File Manager/Db2 edit models
    This topic explains how to use edit models to create batch JCL to access File Manager/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 FM/Db2 functions in batch jobs

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

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

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