KSAB SOFTWARE
Building skills for better tomorrow
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
IDMS/ADSO courses outline
The IDMS/R Environment
1. The Database Environment
2. Data Integrity
3. Application Development Productivity
4. Database Architectures
5. The Dual Nature of IDMS/R
6. The IDMS/R DBMS Component
7. Summary
Logical Database Structure
1. The Baseball Database
2. Attributes and Relationships
3. Entity-Relationship Diagrams
4. Database Records
5. Record Types Versus Record Occurrences
6. Many with Many Relationships
7. Bachman Diagrams
8. Defining Sets
9. Set Types Versus Set Occurrence
10. Choices in Defining Sets
11. The Schema
12. Sub schemas
13. Types of Set Relationships
14. Hierarchies
15. Network Structures
16. Loops and Cycles
17. Summary
Physical Database Structure
1. Database Areas
2. Multiple Areas
3. Mapping into Files
4. Database Records
5. Summary
Record Characteristics
1. Record Name
2. Record Identifier
3. Storage Mode
4. Record Length
5. Location Mode
6. Area Name
7. Diagramming Record Characteristics
8. Summary
Set Characteristics
1. Set Name
2. Linkage Options
3. MemberShip Option
4. Order Option
5. Duplicates Option
6. Indexed Sets
7. The Data Structure Diagram
8. Set Characteristics
9. Summary
Data Description Language
1. Schemas
2. Schema Name
3. File Names
4. Area Names
5. Record Names
6. Set Names
7. Device Media Control Language Modules
8. Device-Media Description Section
9. Buffer Section
10. Area Section
11. Journal Section
12. Sub schemas
13. Subschema Name
14. Schema and DCML Module
15. Areas
16. Records and Data Elements
17. Sets
18. Summary
Data Manipulation Language
1. IDMS/R Operating Environment
2. The Run Unit
3. Data Manipulation Language
4. Preparing a Program for Execution
5. The DML Processor and the Data Dictionary
6. Additional DML Processor Functions
7. Virtual Storage Layout; DML Statement Execution
8. Sample IDMS/R Application Program
9. ID Division
10.Environment Division
11. Data Division
12. Procedure Division
13. BIND Statement
14. READY Statement
15. Status Checking
16. The AUTOSTATUS Option
17. Database Access
18. The FINISH Statement
DML Retrieval Functions
1. Baseball Database Record Occurrences
2. Plan for Execution
3. Choosing a Retrieval Technique
4. Retrieval by CALC_Key Value
5. OBTAIN Versus FINF\D and GET
6.Duplicate CALC-Key Values
7. Currency
8. Establishing Currencies
9. Retrieving Member Records
10. Walking a Set in a Prior Direction
11. Retrieving the Owner Record
12. Retrieving a Particular Member
13. Retrieving the Current Records
14. Retrieval by Sweeping Areas
15. Retrieval by Sort-Key Value
16. Retrieval by Database-Key Value
17. Retrieval using an Index
18. Summary
DML Data Manipulation Functions
1. READY Statements for Updating
2. The MODIFY Function
3. A MODIFY Example
4. The STORE Statement
5. The ERASE Statement
6.Choosing the ERASE Options
7. The CONNECT and DISCONNECT Functions
8. A CONNECT Example
9. A DISCONNECT Example
10. Testing for Set Membership
11. Testing for an Empty Set
12. Summary
Recovery and Restart
1. IDMS/R Operating Environments
2. Recovery/Restart
3. Immediate Checkpoints
4. Recovering from Failures
5. The Rollback Verb
6.Summary
Locking Facilities
1.Area Locks
2. Area usage Modes
3. Record Locks
4. Implicit Record Locks
5. The KEEP Statement
6.Explicit Lock Example
7.Designing Locks
8. Summary
The ADS/OnLine Environment
1. ADS/OnLine Dialogs
2. ADS/Online Development Tools
3. Application Structure
4. Functions
5. Responses
6. Dialog Functions
7.Dialog Components
8. Dialog Processing
9. ADS/OnLine Processes
10. Summary
Application Generation
1. Application Definition Screen
2. Security Screen
3. Global Record Screen
4. Task Codes Screen
5. Response Definition Screen
6. Function Definition Screen
7.Valid Responses Screen
8. Menu Specification Screen
9. Menu Response Sequence Screen
10. Program Parameter List Screen
11. Summary
Dialogs and the Process Command Language
1. Dialog Structure
2. Process Commands
3. Displaying the Map
4. Dialog Control Commands
5. The INVOKE Command
6.The LINK Command
7. The RETURN Command
8. The TRANSFER Command
9. The LEAVE Command
10. Database Currencies and Record Buffers
11. Database Access Commands
12. Process Commands
13. Map Commands
14. Procedural Commands
15. Miscellaneous Commands
16. Summary
Maps, Dialogs and the Runtime System
1. The OnLine Mapping Facility
2. Generating the Map
3. ADS/OnLine Generator
4. Dialog Definition Screen
5. New Copy/Work Record Specification Screen
6.PreMap Process Definition Screen
7. Response Process Definition Screen
8. Map Display Screen
9. Executing the Application
10. Summary