Technical data

N
NEXT, 5–27
Node, 5–1
Null currency indicators, 5–26
O
Occurrence
owner record, 5–9
record, 5–9
set, 5–6, 5–9
ON ERROR phrase, 4–16, 4–32, 4–37, 7–1
One-to-many relationship, 5–22
OPTIONAL set membership class, 6–8
Oracle CDD/Repository, 1–5, 5–4
Oracle CODASYL DBMS Data Definition
Language (DDL), 1–5
Owner record, 5–6
occurrence, 5–9
OWNER test condition, 6–5, 6–6
P
PARTS database demonstration package
creating, 5–2
loading, 5–2
Place markers
database, 1–4
Pointer, 5–25
Position
empty, 5–27
PRIOR, 5–27
Processing control, database, 1–3
Program structure, 1–1
PROTECTED
access mode, 6–1
allow mode, 6–2
PROTECTED RETRIEVAL
lock, 5–32
lock keeplist, 5–32
usage mode, 6–2
PROTECTED UPDATE
usage mode, 6–2
R
RD entries, 3–3
Read-only
access lock, 6–3
READY statement, 1–3, 4–49, 5–25, 6–1
access mode, 6–1
allow mode, 6–1
record locking, 6–2
Realm
currency indicator, 5–26
nulling a currency indicator, 6–12
Realm (cont’d)
record locking level, 6–2
RECONNECT statement, 1–4, 4–53
set membership options, 4–15
usage, 6–9
Record
current, 5–26
database, 5–5
junction, 5–15
member, 5–6
nulling a currency indicator, 6–12
occurrence, 5–9
owner, 5–6
Selection Expression, 1–4
subschema definition, 5–5
types, 5–5
Record level
record locking, 6–3
Record locking
database, 5–5, 5–25
individual records, 6–2, 6–3
minimizing lock out, 6–3
no-read access locks, 6–3
read-only locks, 6–3
READY statement, 6–2
realm level, 6–2
record level, 6–3
releasing, 6–12
resolving locking conflicts, 6–3
using keeplists, 6–3
Record occurrence, 5–5
Record search access, 1–4
Record type
currency indicators, 5–27
Relationship
many-to-many, 5–15, 5–16
multiset, 5–15
one-to-many, 5–22
simple set, 5–11
Releasing locks
records, 6–12
Report Section of Data Division, 3–3
RETAINING clause, 5–30
RETENTION option, 1–4
ROLLBACK
automatic, 6–4
DML statement, 6–4
statement, 1–3
ROLLBACK statement, 4–57
Run unit, 5–25
currency indicators, 5–26, 5–28
current of, 5–28
nulling a currency indicator, 6–12
Index–5