Corporate Information Services Education Partners Contact Us
 
Legacy Services
Legacy Systems Outsourcing
Legacy Modernization
Legacy to Web
Datacom Migrations
Release Migrations
Database Support
 
TT110
 
 


Course Name: CA-IDMS for the Application Programmer

Course Number: TT110

Description: This course focuses on CA-IDMS/DB database concepts and navigation techniques. Lab exercises will use CA-OLQ to enforce navigation techniques along with coding examples in COBOL for a batch environment. Through a set of structured practice sessions, students will practice coding techniques learned in class. 

Topics of discussion include:

  •  Introduction to CA-IDMS/DB
  •  Organization of data
  •  Data storage
  •  Set structures
  •  Data structure diagram
  •  Database currency
  •  Preparing for database access
  •  Verifying database access results
  •  Retrieving data
  •  Updating data
  •  Protecting data integrity

Duration: 

3 days

Prerequisites:

Students should have a working knowledge of COBOL, MVS JCL and TSO.

Target Audience:

Programmers and others who will write or modify navigational code in the CA-IDMS/DB environment

Objectives: 

Upon completion of this course, student will be able to:

  • Describe the characteristics of CA-IDMS/DB and the effects of programming in that environment
  • Identify records, sets and foreign-key relationships on a data structure diagram
  • Recognize record components on a data structure diagram
  • Identify information on a data structure diagram and indicate importance to a programmer
  • Define currency and give examples of how currency is used in database processing
  • Describe the requirements for accessing a database
  • Use ERROR-STATUS, IDMS-STATUS & AUTOSTATUS
  • Write the code to retrieve and store data
  • Explain how the database is protected from concurrent update or abnormal program termination
  • Access CA-IDMS/DB database structures using CA-OLQ as well as coding DML statements