IMS - DB  

Course	Introduction to IMS DB Application Programming
Level	Introductory
Overview	The participants will be introduced to the concepts and features of IMS – Database. The course describes how application programs interact with IMS facilities. The participants will learn how to code and debug IMS DB programs written in COBOL. Lab sessions will help in reinforcing the concepts discussed during lectures.
Objective	On completing this course, participants will be able to - Understand the IMS functions and facilities. Describe the IMS database organizations and their processing. Develop programs to access IMS databases sequentially as well as directly.
Duration	Four (04) days: (09.30AM till 17.30AM)
Participant's Profile	Application programmers who will code and debug COBOL application programs for IMS Database.
Prerequisite	Basic knowledge of programming in COBOL. Working knowledge of TSO, ISPF and JCL.
Follow-on session	Mock or Live Project hands on is recommended after this course.
Course Contents	Day – 1 Introduction to IMS IMS environment IMS components IMS large system environment IMS - CICS connectivity IMS - DB2 attachment IMS Database Manager Limits of file systems DL/1 environment Hierarchical databases IMS DB terminology IMS Database Definition Responsibilities of a DBA DBDGEN process PSBGEN process Lab Session – 1 Day – 2 DL/1 Application Programs Application program components Control blocks and database relationships IMS programming conventions IMS Entry linkage Database call format DL/1 call functions Segment Search Arguments Accessing IMS databases Random retrieval Sequential retrieval Loading and inserting segments Deleting and updating segments Exercises Lab session – 2 Day – 3 Advanced SSAs Command Codes Command codes L and F Command codes D and N Command code P Command code C Command codes U and V Boolean operators in SSAs Exercises Lab Session – 3. Day – 4 Programming Techniques Using PCB masks Descending sequence Parallel processing in a database Multiple positioning Variable length segments Secondary indexing Lab session – 4 .