Profience

DB2 COBOL API Programming

Why take this course?

After completing this course, you will be able to
  • code SQL Data Manipulation Language (DML) for online and batch programs.
  • prepare and test a program containing SQL.
  • program for DB2's concurrency and referential integrity features.
  • use DB2's security and authorization features, and understand the implications for program execution.


Gain the skills you need to code application programs in the DB2 environment. We'll explain the logic and coding required to incorporate DB2 database access into COBOL programs that execute in interactive and batch mode. We'll also show you the DB2 facilities in ISPF that are available to help programmers.

Who should attend?

COBOL programmers who develop or help develop DB2 applications.

Any prerequisites?

You should have basic TSO/ISPF skills as well as experience with the standard SQL syntax for INSERT, UPDATE, DELETE and SELECT, and a general understanding of application programming.

Dates and Fees

2 Days   ? - $ 737 (CAD) ? Up to 3 - $ 1,477 Up to 6 - $ 2,214   ? Plus - $ 367
 
Sorry, no classes are currently scheduled, please contact us to request a class
Contact us to arrange your preferred date and/or in-class training

What Topics are covered?

Program Preparation
  • DB2 Environments
  • Programmed Environment
  • Traditional Program Preparation
  • DB2 Program Preparation
  • Precompile
  • Compile and Link-Edit
  • BIND
  • Using Packages
  • REBIND
  • Preparing Multi-Module Programs
  • Program Execution (TSO)
  • Tools and Aids
  • DB2 Interactive (DB2I)
  • DB2I PRIMARY OPTION MENU
  • DB2I BIND/REBIND/FREE Menu
  • BIND JCL (Job Control Language)
  • BIND PLAN Control Statement
  • BIND Package Control Statement
Application Coding
  • Program Elements
  • Coding SQL Statements
  • Host Variables
  • Defining Host Variables
  • Using Host Variables
  • Host Structures
  • SQLCA
  • Table Declaration
  • DCLGEN
  • DB2 Main Menu
  • DCLGEN Panel
  • DCLGEN Output
  • Workshops Overview
  • SELECT in Programs
  • SELECT INTO
  • SQLCA
  • SQLCA Fields
  • SQL Warning Indicators
  • SQLCODE
  • Checking SQLCODE
  • WHENEVER
  • INSERT, UPDATE, DELETE
  • INSERT
  • UPDATE
  • DELETE
  • Indicator Variables
  • Why Cursors?
  • Elements of CURSOR Processing
  • Statements
  • DECLARE . . . CURSOR
  • OPEN/CLOSE
  • FETCH
  • Cursor Processing Flow
  • Temporary Result Table
  • UPDATE through a Cursor
  • DELETE through a Cursor
  • Application Program Coding
Referential Integrity
  • What is Referential Integrity
  • Implementation Alternatives
  • Enforcing Referential Integrity
  • Defining Referential Integrity
  • Design Considerations
  • Basic Concepts
  • DELETE Rules
  • Operational Implications
  • CHECK
Concurrency Control
  • Why Concurrency Control?
  • DB2 Locking Strategy
  • Lock Size
  • Lock Mode
  • Logical Unit of Work
  • Lock Duration
Security and Authorization
  • Application Security
  • Authorization Id
  • Flavours of the AUTHID
  • Primary AUTHID
  • Secondary AUTHID
  • Current SQLID
  • Data Control Language
  • GRANT
  • REVOKE
  • Ownership Privileges
  • Application Plan
DB2 Batch Processing
  • Program Logic
  • Point of Consistency
  • Rollback
  • Savepoint
  • Execution JCL

Competency Assessment and Certificate

At the request of the person booking, a technical competency assessment will be conducted with the student.
This assessment will be a combination of written and multiple choice questions as well as specific coding tests.
Upon a minimum pass rate of 85%, students will receive a Certificate of Competency instead of the standard certificate of course completion.
Please Contact us for more details or specific needs.