Compaq COBOL
DBMS Database Programming Manual

Contents

Preface
Preface	Preface
Chapter 1
1	Program Organization and Structure
1.1	Program Structure
1.2	Compaq COBOL Data Manipulation Language (DML)
1.3	Creating a Compaq COBOL DML Program
1.4	Compiling a Compaq COBOL DML Program
1.4.1	Copying Database Records in a Compaq COBOL Program
1.4.2	Using the /MAP Compiler Qualifier
1.5	Linking a Compaq COBOL DML Program
1.6	Running a Compaq COBOL DML Program
Chapter 2
2	Database Programming Elements of Compaq COBOL
2.1	Database-Related User-Defined Words
2.2	Database-Related Reserved Words
2.2.1	DB-CONDITION
2.2.2	DB-CURRENT-RECORD-NAME
2.2.3	DB-CURRENT-RECORD-ID
2.2.4	DB-KEY
2.2.5	DB-UWA
Chapter 3
3	Data Division
3.1	DATA DIVISION General Format and Rules
Command 1	DB (Subschema Description)
Command 2	LD (Keeplist Description)
Chapter 4
4	Procedure Division
4.1	COBOL Statements for the Database Programmer
4.1.1	Compiler-Directing Statements and Sentences
4.1.2	Imperative and Conditional Statements and Sentences
4.2	Explicit and Implicit Scope Terminators
4.3	Scope of Names
4.4	Database Key Identifiers
4.5	Database Conditions
4.5.1	Tenancy Conditions
4.5.2	Empty Condition
4.5.3	Database Key Condition
4.5.4	Condition Evaluation Rules
4.6	Record Selection Expressions (RSE)
4.7	Set Membership Options and DML Verbs
4.8	Programming for Database Exceptions and Error Handling
4.8.1	Database On Error Condition
4.8.2	At End Condition
4.8.3	Exception Conditions and the USE Statement
4.8.4	Translating DB-CONDITION Values to Exception Messages
4.9	Database Programming Statements in the COBOL Procedure Division
Command 3	COMMIT
Command 4	CONNECT
Command 5	DISCONNECT
Command 6	ERASE
Command 7	FETCH
Command 8	FIND
Command 9	FREE
Command 10	GET
Command 11	KEEP
Command 12	MODIFY
Command 13	READY
Command 14	RECONNECT
Command 15	ROLLBACK
Command 16	STORE
Command 17	USE
4.9.1	RETAINING Clause
Chapter 5
5	Database Programming with Compaq COBOL
5.1	The Self-Paced Demonstration Package
5.2	Concepts and Definitions
5.2.1	Database
5.2.2	Schema
5.2.3	Storage Schema
5.2.4	Subschema
5.2.5	Stream
5.3	Using Oracle CDD/Repository
5.4	Database Records
5.5	Database Data Item
5.6	Database Key
5.7	Record Types
5.8	Set Types
5.9	Sets
5.9.1	Simple Set Relationships
5.9.1.1	System-Owned Sets
5.9.1.2	Simple Sets
5.9.1.3	Forked Sets
5.9.2	Multiset Relationships
5.9.2.1	Many-to-Many Relationships Between Two Types of Records
5.9.2.2	Many-to-Many Relationships Between Records of the Same Type
5.9.2.3	One-to-Many Relationships Between Records of the Same Type
5.10	Areas
5.11	Realms
5.12	Run Unit
5.13	Currency Indicators
5.13.1	Current of Realm
5.13.2	Current of Set Type
5.13.3	Current of Record Type
5.13.4	Current of Run Unit
5.14	Currency Indicators in a Compaq COBOL DML Program
5.14.1	Using the RETAINING Clause
5.14.2	Using Keeplists
5.14.3	Transactions and Quiet Points
Chapter 6
6	DML Programming---Tips and Techniques
6.1	The Ready Modes
6.1.1	Record Locking
6.2	COMMIT and ROLLBACK
6.3	The Owner and Member Test Condition
6.4	Using IF EMPTY Instead of IF OWNER
6.5	Modifying Members of Sorted Sets
6.6	CONNECT and DISCONNECT
6.7	RECONNECT
6.8	ERASE ALL
6.9	ERASE Record-Name
6.10	Freeing Currency Indicators
6.10.1	Establishing a Known Currency Condition
6.10.2	Releasing Record Locks
6.11	FIND and FETCH Statements
6.12	FIND ALL Option
6.13	FIND NEXT and FETCH NEXT Loops
6.14	Qualifying FIND and FETCH