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