DB2/CICS Workshop

Course:  DB2CICS
Duration:  5 Days
Level:  II
Course Summary

This workshop uses the 'HANDS ON' approach to teach application programmers or designers the essential concepts of programming in the CICS environment with DB2 (current or any release).

« Hide The Details
Topics Covered In This Course

CICS overview

How CICS and DB2 connect

CICS Entries

CICS and SQL commands

Pre-compiler and Translator

Execute Interface Block (EIB) and Function Keys

Communications area (DFHCOMMAREA)

Basic Mapping Support (BMS)

Programming in the CICS environment

Pseudo Conversational programming

Accessing DB2

Handling SQL errors


Using the CICS screen cursor

Adjusting Screen Attributes

Using Cursors

Using Map Fields in SQL

Temporary Storage Queues

What You Can Expect

At the end of this course, participants will be able to:

  • Understand the basic components of CICS and DB2
  • Understand how CICS runs and connects to DB2
  • Code and execute CICS Command Level programs with DB2
  • Use Basic Mapping Support Macros
  • Debug CICS programs using CEDF
  • Accessing DB2 Tables in CICS
  • Understand Temporary Storage
  • Understand the use of Cursors in CICS
Who Should Take This Course

Application and system programmers, designers interested in gaining an understanding of CICS and DB2 programming.

Training Style

Instructor led with hands on workshops

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]