Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » CICS Transaction Server Curriculum » CICS TS Programmers Series 5.3

Files and Databases

Duration
4 hours

Overview

Description

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 learner should 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

Course Catalog » CICS Transaction Server Curriculum » CICS TS Programmers Series 5.3
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM