self evaluation testing

Existing User




If you are a existing user

click here to login



New User




If you are a new user

click here to register



Other Links





            skills development


            references


            feedback

IMS DB courses outline

Introduction

1. IMS Systems and DL/I. IMS Terminology
2. IMS Database Definition. Hierarchical Sequence
3. Create DBD and PSB. PROC options. PCB Mask. Key feedback area
4. Segment types and occurrences , sequence fields, search fields, SENSEG statements

Database Programming

1. Changes required in COBOL programming to make IMS calls
2. IParentage and Position in a database. Sequential retrieval of segments
3. Get Next call - Sequential retrieval of segments
4. Get Unique call - Random retrieval of segments
5. Get Next within Parent call - retrieval of segments under a given parent

SSA Overview

1. Unqualified calls. Qualified calls
2. Unqualified SSAs, Qualified SSAs
3. Multiple qualification in SSAs
4. Understanding current position in the database after a successful call and after an unsuccessful call
5. IMS error codes encountered while running programs – GE,GB,II,GK,LB

Database Loading

1. Loading and Inserting segments. ISRT call
2. PROC options to be used when loading a database for the first time

Deleting and Upating segments

1. GHU , REPL and DLET calls

Usage of Command Codes

1. L, F, D, U, V and other command codes

Recovering databases and maintaining database integrity

1. Issuing checkpoints
2. Restarting your program and checking for position
3. Backing out database changes for database integrity
4. Basic and Symbolic checkpoints
5. CHKP, XRST , ROLL calls

Organization and access methods in IMS

1. HS and HD access methods. HDAM, HIDAM, HSAM, HISAM, GSAM organizations

Case Study:

1. Banking or Insurance project
2. Project related hints and tips