Profience

DB2 CICS Application Programming Workshop

Why take this course?

After completing this course, you will be able to
  • understand CICS concepts, structure & facilities
  • use Basic Mapping Support & generate user screens
  • use pseudo-conversational programming techniques
  • write programs which take full advantage of CICS features
  • embed SQL statements in COBOL programs
  • show on a screen single and multiple rows returned from a query
  • handle user request to insert, update, and delete from DB2 tables
  • fix common problems using interactive tools in CICS & DB2

This hands-on course gives you a firm foundation in the skills you need to create and maintain interactive applications that execute in IBM's CICS environment and process data in DB2 tables. You will create a full operating DB2 CICS application: from defining its screens to writing programs that perform functions typical of business applications. The course will also show you how to use CICS provided transactions to unit test and debug your application and the DB2 Interactive option in ISPF to prepare the program for execution.

Who should attend?

Intermediate and experienced application programmers who need CICS skills.

Any prerequisites?

You should have experience with COBOL at the level of the course COBOL Programming Workshop , be comfortable with TSO/ISPF Essentials , and have basic SQL knowledge such as provided through the course DB2 11 for z/OS SQL Queries Workshop .

Dates and Fees

5 Days   ? - $ 1,747 (CAD) ? Up to 3 - $ 3,494 Up to 6 - $ 5,244   ? Plus - $ 874
 
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?

Introduction to CICS
  • CICS Overview
  • CICS Security
  • CICS Application Development
  • DB2 Considerations
  • IMS Considerations
  • Testing in CICS
  • Workshop
CICS Commands
  • CICS Processing
  • Command Basics
  • Commands
  • RECEIVE
  • SEND Text
  • ASKTIME
  • FORMATTIME
  • ASKTIME and FORMATTIME
  • Compiling and Link Editing
  • CICS Translation
  • Coding Restrictions
Basic Mapping Support
  • How it works
  • Physical Maps
  • Symbolic Maps
  • BMS Advantages
  • Screen Development
  • Mapset Definition
  • Map Definition
  • Field Definition
  • Assembling Maps
  • Testing Maps
Programming Basics
  • Types of Programming
  • Execute Interface Block
  • Exception Handling
  • Sending and Receiving Maps
  • Terminal Control
Structured CICS Programming
  • CICS Program Construction
  • WORKING-STORAGE Section
  • Linkage Section
  • Procedure Division
  • Application Overview
Program Control
  • Application Framework
  • Giving Control to Other Program
  • LINK Command
  • XCTL Command
  • XCTL vs. LINK
  • CALL Command
  • LOAD Command
Testing and Debugging
  • Native Commands
  • Command Level Interpreter
  • Execution Diagnostic Facility
  • Master Terminal Commands
Database Access
  • DB2 Program Preparation
  • DB2 Interactive Tools
  • DB2 Program Execution
  • DB2 Program Elements
  • Single Row SELECT
  • Error Handling
  • INSERT, UPDATE, and DELETE
  • Handling NULLS
  • Multiple Row SELECT
  • Locking and Performance
  • ENQUEUE Command
  • DEQUEUE Command
  • CICS Exception Conditions
Temporary Storage and Transient Data
  • Temporary Storage Concepts
  • Temporary Storage Commands
  • TS Queue Management
  • Transient Data
  • Transient Data Commands
  • TD Queue Management
  • Queue Comparison
Abnormal Termination and Recovery
  • ABENDS
  • Unexpected ABENDS
  • Controlled ABENDS
  • CICS Recoverable Resources
  • Recovery Mechanism
  • Logical Unit of Work (LUW)
  • SYNCPOINT Command
  • Dynamic Transaction Backout