Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Mainframe Links
Mainframe Facts - Did you know?


More facts...

Course Catalog » Database Curriculum

Create and Maintain DB2 Programs V10

6 hours



The Create and Maintain DB2 Programs course describes how SQL is invoked from an application program and the interaction that can occur between the application program and DB2. This course also discusses how a DB2 COBOL Program can be created.


Programmers and DBAs requiring training in writing application programs to reference and update DB2 data, particularly in the mainframe environment.


Completion of the courses ‘Manage Data Definitions with DB2' and ‘Manage Data with DB2 - SQL', and basic knowledge of DB2, relational databases, and system design.


After completing this course, the student will be able to identify how the following programs are written with DB2:

  • Report programs
  • Data inquiry programs
  • Data update programs

Course Content

Embedding SQL in an Application Program

Steps Required to Prepare an Application Program with Embedded SQL for Execution

Manipulating Data and Components of an Application Program

Codes Returned from DB2 to an Application Program

Host Variables that Pass Values between an Application Program and DB2


The Cursor

The Scrollable Cursor

Commit Points and Save Points

Commit Points and their Effect on Cursor

DB2 Rollbacks and How to Force One

Save Points

Writing a DB2 COBOL Program

Build a Program That Issues Simple SQL Statements to DB2

Writing a DB2 COBOL Cursor Update Program

Writing a DB2 COBOL Program by Using a Cursor

Writing a DB2 COBOL Update Program by Using a Cursor

Create and Maintain DB2 Programs Mastery Test

Course Catalog » Database Curriculum
  © All rights reserved. Interskill Learning Pty Ltd.
  HomeAbout UsProductsDemonstrationCourse CatalogContact UsSite Map
      Interskill IBM