Technical data

Database (cont’d)
conditional expression, 1–4
CONNECT statement, 6–8
copying database records, 1–5
creating, 5–3
creating an HP COBOL DML program, 1–4
creating new record relationships, 8–22
creating records, 1–4
currency indicators, 5–25, 5–28
example, 5–28
freeing, 6–12
example, 6–13
null, 5–26
realm, 5–26
record type, 5–27
run unit, 5–26, 5–28
saving, 5–30
See also Currency indicators, 5–25
set type, 5–27
Database Control System, 1–6
Data Definition Language, 1–5
data item, 5–5
data manipulation language, 1–3
See also DML statements
DBQ utility, 7–1, 7–2
DB statement, 1–5
debugging DML programs, 7–1
sample session, 7–2
definition of, 5–3
degree of record locking, 5–5
deleting records, 1–4, 6–10
demonstration package, 5–1
creating, 5–2
loading, 5–2
designing, 5–3
DISCONNECT statement, 6–8
entry points into, 5–11
ERASE ALL statement, 6–10
ERASE statement, 6–11
erasing records for, 1–4
error handling, 4–15
error-handling routines, 4–16
establishing a known currency condition, 6–12
exception conditions
AT END phrase, 4–17
ON ERROR phrase, 4–16, 4–18
translating DB-CONDITION values, 4–19
USE statement
example, 4–19
exception handling, 4–15
FETCH NEXT, 6–15
FETCH statement
qualifying, 6–17
FIND ALL statement, 6–14
finding records, 1–4
FIND NEXT, 6–15
FIND statement
qualifying, 6–17
Database (cont’d)
forked sets, 5–13
IF EMPTY clause, 6–6
keeplists, 5–32
key, 5–5
key identifier access, 1–4
linking an HP COBOL DML program, 1–5
locking out other users, 6–2
logical division, 5–25
maintaining, 5–3
many-to-many relationships
records of the same type, 5–17
two types of records, 5–15
MEMBER test condition, 6–5
minimizing lock out, 6–2
modifying members of sorted sets, 6–6
modifying records, 1–4
multiset relationships, 5–15
example, 8–17, 8–22
NEW.ROO, 5–2
one-to-many relationsships
records of the same type, 5–22
Oracle CDD/Repository, 5–4
OWNER test condition, 6–5
physical division, 5–24
place markers, 1–4
processing control, 1–3
program examples, 8–1
accessing database information, 8–15,
8–17
backing up a database, 8–9
creating relationships, 8–17, 8–22
displaying database information, 8–15,
8–17
populating a database, 8–1
programming techniques, 6–1
READY usage modes, 6–1
See also READY statement, Access
mode, and Usage mode
protected access, 6–2
quiet points, 5–34
figure, 5–34
reading a subschema map listing
example, 7–10, 7–13, 7–14, 7–19
read-only access, 6–2
realms, 5–25
RECONNECT statement, 6–9
record, 5–5
record deleting, 1–4
record locking, 5–25, 6–2
See also Record locking
individual records, 6–2
READY statement, 6–2
realm level, 6–2
record level, 6–3
releasing locks, 6–14
record retrieval, 1–3
record transfers, 6–9
Index–2