Technical data

5
Database Programming with HP COBOL
With HP COBOL database programming you can access data without
designing separate files for specific applications. You accomplish this with the
database management system (Oracle CODASYL DBMS) and the COBOL data
manipulation language (DML). This chapter is a resource for information on:
• HP COBOL database program development
• HP COBOL database concepts
• HP COBOL programming tips and techniques
• Debugging and testing HP COBOL database programs
Database programmers and readers unfamiliar with Oracle CODASYL DBMS
concepts and definitions should run the online self-paced demonstration package
(see Section 5.1) as a prerequisite to this chapter. The demonstration package
lets you test Oracle CODASYL DBMS features and concepts as you learn them.
Additional useful information can be found in:
• Introduction to Oracle CODASYL DBMS
• Oracle CODASYL DBMS Database Administration Reference Manual
5.1 The Self-Paced Demonstration Package
To help you learn how to use a database, Oracle has provided you with a database
called PARTS. PARTS is an online self-paced demonstration database configured
to show some of the features of Oracle CODASYL DBMS. You create the PARTS
database as part of the demonstration package. Examples in this chapter refer
to either the PARTSS1 or PARTSS3 subschema in the PARTS database. A
complete listing of the PARTS schema, including the PARTSS1 and PARTSS3
subschemas, can be found in the Oracle CODASYL DBMS documentation on data
manipulation.
Before beginning the demonstration, you should do the following:
1. Create your own node in Oracle CDD/Repository using the Dictionary
Management Utility (DMU). (Refer to the Oracle CDD/Repository
documentation for more information.)
$ RUN SYS$SYSTEM:DMU
RET
DMU> CREATE nodename
RET
DMU> SHOW DEFAULT
RET
defaultname
DMU> EXIT
RET
$
Database Programming with HP COBOL 5–1