Interskill Learning Mainframe Training

770-872-4278

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

CICS TS - Files and Databases 5.6

Duration

4 hours

Overview

This course discusses how CICS applications can be used to access and update data, and also looks at the code and interfaces required by CICS to communicate with Db2.

Audience

Applications and Systems Programmers who need to understand the methods used by CICS programs when accessing, and updating file and database data.

Prerequisites

    Completion of the following Interskill course, or equivalent knowledge:
  • CICS TS - Program Control and Communication

Objectives

    After completing this course, the student will be able to:
  • Identify CICS commands that are used to directly read, insert, update, and delete records in files
  • Describe the CICS commands that are used to sequentially read records in files
  • Describe how CICS programs can interact with Db2

Course Content

Accessing Files

Supported Files
CICS File Definitions
CICS READ Command
Parameters used to Locate a Record
Read for Update
CICS WRITE Command
Mass Inserts
CICS REWRITE Command
Deleting a File
Record Locking

Accessing File Data Sequentially

Identifying the Beginning or End of a File
Browsing Multiple Files at One Time
Browsing Best Practices
CICS STARTBR and ENDBR Browse Commands
Using Partial or Generic Keys
CICS READNEXT and READPREV Commands
Repositioning using the CICS RESETBR Command

Using Db2 with CICS

CICS and Db2
CICS Syncpointing and Recovery
CICS-Db2 Attachment Facility
CICS Threads
CICS on z/OS Features
Accessing Db2 Data using EXEC SQL, Java, and REXX
Db2 Preprocessor, and Binding
Plans and Packages
Performance Considerations

CICS TS - Files and Databases Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278