|
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; DML Retrieval Statements 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; ASF Overview 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;
Duration
15 hrs
Minimum Requirements
IBM Compatible PC CGA Monitor 512K RAM 3.0MB Hard Disk Space DOS 3.3 or Higher Copyright © 1997 FirstClass Systems Corporation.
Media
Diskette
|
