Technical data

4.8 Programming for Database Exceptions and Error Handling ........... 4–15
4.8.1 Database On Error Condition . . . ............................ 4–15
4.8.2 At End Condition ......................................... 4–17
4.8.3 Exception Conditions and the USE Statement ................... 4–18
4.8.4 Translating DB-CONDITION Values to Exception Messages ........ 4–19
4.9 Database Programming Statements in the COBOL Procedure Division . . 4–20
COMMIT .................................................. 4–21
CONNECT ................................................. 4–23
DISCONNECT . . ............................................ 4–26
ERASE .................................................... 4–28
FETCH ................................................... 4–31
FIND . .................................................... 4–35
FREE . .................................................... 4–39
GET...................................................... 4–41
KEEP . .................................................... 4–43
MODIFY .................................................. 4–45
READY ................................................... 4–49
RECONNECT . . ............................................ 4–53
ROLLBACK ................................................ 4–57
STORE .................................................... 4–59
USE...................................................... 4–62
4.9.1 RETAINING Clause . . . .................................... 4–66
5 Database Programming with HP COBOL
5.1 The Self-Paced Demonstration Package ........................... 5–1
5.2 Concepts and Definitions . . .................................... 5–2
5.2.1 Database . . . ............................................ 5–3
5.2.2 Schema ................................................ 5–3
5.2.3 Storage Schema .......................................... 5–3
5.2.4 Subschema . . ............................................ 5–3
5.2.5 Stream ................................................. 5–3
5.3 Using Oracle CDD/Repository .................................. 5–4
5.4 Database Records ............................................ 5–5
5.5 Database Data Item .......................................... 5–5
5.6 Database Key . . . ............................................ 5–5
5.7 Record Types . . . ............................................ 5–5
5.8 Set Types .................................................. 5–6
5.9 Sets . . .................................................... 5–9
5.9.1 Simple Set Relationships ................................... 5–11
5.9.1.1 System-Owned Sets .................................... 5–11
5.9.1.2 Simple Sets .......................................... 5–12
5.9.1.3 Forked Sets .......................................... 5–13
5.9.2 Multiset Relationships . .................................... 5–15
5.9.2.1 Many-to-Many Relationships Between Two Types of Records . . . . 5–15
5.9.2.2 Many-to-Many Relationships Between Records of the Same
Type................................................ 5–17
5.9.2.3 One-to-Many Relationships Between Records of the Same
Type................................................ 5–22
5.10 Areas . .................................................... 5–24
5.11 Realms .................................................... 5–25
5.12 Run Unit .................................................. 5–25
iv