CA-IDMS/R Application Programming (ver 10.2)

Outline

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

Description

Explains CA-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

IDMS/R Overview Database Principles; Types of Databases; Capabilities and Applications; IDMS/R Features; Records and Sets I Relationships Between Record Types; Chained and Indexed Sets; Set Linkage; Set Membership Options; Records and Sets II Sort Order; Multiple Membership, Ownership and Sets; Set Hierarchies; Physical Structure I Database Keys; Pages, Areas and Files; Location Modes; Physical Structure II Schema; Subschema; Device-Media Control Language; Bachman Diagrams;Segments;Database Name Tables; Operating Environment Central Version vs Local Mode 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; FIND; GET; OBTAIN; DML Modification Statements STORE; MODIFY; CONNECT; DISCONNECT; ERASE and SAVE Statements Function of Each Statement; Syntax; Sample Code; Using SQL with Non SQL databases; Schemas; Tables; Columns; Submitting SQL; INSERT; UPDATE; DELETE; SELECT; Using ASF Uses of ASF; Functions of ASF; Stored Tables and Views; Relational Operations; Using ASF ASF Screens; Screen Format; Screen Management; Creating Data Tables Defining and Creating a Stored Table; Loading, Displaying, Changing, Deleting Data; Creating a View;

© Copyright Serebra Learning Corp., 2002