IDMS

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

Explains IDMS structure and environment, teaches how to access and manipulate records and sets, and details how they are physically stored in the database.

Audience

Programmers, analysts and systems designers.

Prerequisites

An understanding of database principles.

Topics Include

Record and Sets

• Features of Centralized Data Management
• Relationships Between Records and Sets
• Set Membership Options
• Multiple Membership, Ownership and Sets

Physical Structure

• IDMS Records
• Pages, Areas and Files
• Location Modes

Data Structure

• Introduction to Schemas, Subschemas and the Device
• Media Control Logic
• Use of Bachman Diagrams

Operating Environment

• Central Version vs Local Model Journalling
• Recovery Procedures
• Compiler Options
• Compiler - Directive Statements

Currency Concepts

• What is Currency?
• Current of Run Unit
• Current of Record Type
• Current of Set
• Current of Area

Record and Area Locks

• What are Record and Area Locks?
• Types of Record Locks
• Usage Modes
• Run-Time Considerations
• Area Locks

DML Control Statements

• BIND
• READY
• FINISH
• KEEP
• COMMIT
• IF
• ROLLBACK

DML Retrieval Statements

• FIND
• GET
• OBTAIN

DML Modification Statements

• STORE
• MODIFY
• CONNECT
• DISCONNECT

ERASE and SAVE Statements

• Function of Each Statement
• Syntax

Duration

10 hrs

Minimum Requirements

CGA Color Monitor; 512K RAM; 2.1MB Hard Disk Space; DOS 3.3 or Higher  

Media

Diskette
CDROM
Web Based Training

© Copyright Serebra Learning Corp., 2002