Interskill Learning Mainframe Training

American English British English Brazilian Portuguese French German Italian Russian Spanish (European) Spanish (Latin American)
+44 (0) 1625 441120

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

CICS - Files and Databases

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:
  • 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

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
Deadlocks

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
EXEC SQL Statements
REXX/CICS DB2 Interface
DB2 Preprocessor, and Binding
Plans and Packages
Performance Considerations

Files and Databases Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at +44 (0) 1625 441120