Compaq COBOL
DBMS Database Programming Manual

Chapter 7
7	Debugging and Testing Compaq COBOL DML Programs
7.1	DBQ Commands and DML Statements
7.2	Sample Debugging and Testing Session
7.3	Program Map Listings on Alpha or VAX
7.3.1	Listings on Alpha
7.3.2	Listings on VAX
Chapter 8
8	Database Programming Examples
8.1	Populating a Database
8.2	Backing Up a Database
8.3	Accessing and Displaying Database Information
8.4	PARTBOM Sample Run
8.5	Creating Relationships Between Records of the Same Type
8.6	STOOL Program Parts Breakdown Report---Sample Run
8.7	Creating New Record Relationships
8.7.1	PERSONNEL-UPDATE Sample Run---Listing Before Promotion
8.7.2	PERSONNEL-UPDATE Sample Run---Listing After Promotion
Appendix A
Appendix A	COBOL Database Programming Reserved Words
Glossary
Glossary	Glossary
Index
Index
Examples
4-1	A Single USE Statement
4-2	Multiple USE Statements
5-1	Printing a Listing of a Simple Set
5-2	Using Forked Sets
5-3	Currency Indicators
5-4	Using the RETAINING Clause
6-1	ROLLBACK Statement
6-2	Owner and Member Test Condition
6-3	RECONNECT Statement
6-4	FREE CURRENT Statement
6-5	FETCH NEXT Loop
6-6	Using a FETCH NEXT Loop to Walk Through a Set Type
7-1	Sample Compaq COBOL DML Program Statements
7-2	Sample DML Program Statements
7-3	PARTSS1-PROGRAM Compiler Listing (Alpha)
7-4	PARTSS3-PROGRAM Compiler Listing (Alpha)
7-5	PARTSS1-PROGRAM Compiler Listing (VAX)
7-6	PARTSS3-PROGRAM Compiler Listing (VAX)
8-1	Populating a Database
8-2	Backing Up a Database
8-3	Accessing and Displaying Database Information
8-4	Sample Run of the PARTBOM Program
8-5	Creating Relationships Between Records of the Same Type
8-6	Creating New Record Relationships
8-7	Sample Run of PERSONNEL-UPDATE Before Promotion
8-8	Sample Run of PERSONNEL-UPDATE After Promotion
Figures
1-1	Structure of a COBOL Program
1-2	Database and Application Program Relationship
4-1	Usage Mode Conflicts
5-1	Bachman Diagram
5-2	Partial Bachman Diagram of the PARTSS1 Subschema
5-3	Bachman Diagram of the PARTSS3 Subschema
5-4	Sample Occurrence Diagram 1
5-5	Sample Occurrence Diagram 2
5-6	One Occurrence of Set PART_SUPPLY
5-7	Set Relationship
5-8	Set Relationships
5-9	Occurrence Diagram of a Relationship Between Two Set Types
5-10	Bachman Diagram of a System-Owned Set Type
5-11	Bachman Diagram of a Simple Set Type
5-12	Bachman Diagram of a Forked Set Type
5-13	Forked Set Occurrence
5-14	Bachman Diagram of a Many-to-Many Relationship Between Two Types of Records
5-15	Many-to-Many Relationship Between Two Types of Records
5-16	Bachman Diagram of a Many-to-Many Relationship Between Records of the Same Type
5-17	Current of PART_USES and PART_USED_ON
5-18	Retain PART_USES Currency
5-19	COMPONENT Is Connected to Both Set Types
5-20	Finding the Stool Legs While Keeping STOOL Current of PART_USES
5-21	Completed Bill of Materials
5-22	Occurrence Diagram of a Many-to-Many Relationship Between Records of the Same Type
5-23	Sample Parts Breakdown Report
5-24	One-to-Many Relationship Between Records of the Same Type
5-25	Sample Data Prior to Update
5-26	Sample Data After Update
5-27	Database Relationships
5-28	Currency Status by Executable DML Statement
5-29	Physical Representation of a Realm Without a RETAINING Clause
5-30	Physical Representation of a Realm with a RETAINING Clause
5-31	State of KEEPLIST-1 After Executing Line 000160
5-32	State of KEEPLIST-1 After Executing Lines 000190 and 000200
5-33	Transactions and Quiet Points
6-1	Using the COMMIT Statement
6-2	Occurrences of the RESPONSIBLE_FOR Set Type
6-3	Modifying Members of Sorted Sets
6-4	After Modifying MEMBER_B and Using RETAINING
6-5	Occurrence Diagram Prior to RECONNECT
6-6	Occurrence Diagram After RECONNECT
6-7	Results of an ERASE ALL
6-8	Results of an ERASE Record-Name (with Both OPTIONAL and FIXED Retention Classes)
6-9	Record Locking
6-10	Using FIND NEXT and FETCH NEXT Loops
7-1	Split Screen After FETCH FIRST PART USING PART_ID
7-2	Split Screen After FETCH NEXT WITHIN PART_SUPPLY
7-3	Split Screen After MODIFY SUP_RATING
7-4	Split Screen After FETCH OWNER WITHIN VENDOR_SUPPLY
7-5	Split Screen After FETCH CURRENT PART RETAINING PART_SUPPLY
7-6	Split Screen After FETCH NEXT WITHIN PART_SUPPLY
7-7	Split Screen After FETCH 2 WITHIN PART_SUPPLY
Tables
2-1	COBOL Database-Related User-Defined Words
3-1	Compaq COBOL and DDL Utility Data Type Equivalences
4-1	Types of COBOL Statements
4-2	Contents of COBOL Sentences