---

IMS Database (DB) Coding

Course Abstract: This course is designed for application programmers requiring a detailed understanding of IMS database processing.

Duration: 5 days

Primary Audience: Application programming personnel.

Prerequisites: COBOL or PL/I, TSO, JCL, IMS Concepts.

Course Objectives: Upon successful completion of this course, the student should be able to:

• Code programs utilizing efficient retrieval, replace, delete and insert calls to IMS databases
• Design, code and test restartable programs using symbolic checkpoint/restart and GSAM databases

Class Format: Lecture with hands-on exercises.

Cost: In-house: $8,500 for up to 15 students; $500 for each additional student. Public: $2,495.

Topics:

• Hierarchical Structures and Associated Terminology
• Coding of Call Functions, PCBs, I/O Areas, SSAs, Entry Statement
• · Status Code Checking
• Testing with BTS
• Sequential vs. Random Processing
• Parentage, Command Codes and Boolean SSAs
• Database Positioning
• Secondary Indexes
• IMS Access Methods (including GSAM)
• IMS JCL Requirements (BMP vs. DLI Batch)
• Checkpoint/Restart