Technical data

5–8 Set Relationships . ........................................ 5–11
5–9 Occurrence Diagram of a Relationship Between Two Set Types ...... 5–11
5–10 Bachman Diagram of a System-Owned Set Type . . ............... 5–12
5–11 Bachman Diagram of a Simple Set Type ....................... 5–12
5–12 Bachman Diagram of a Forked Set Type ....................... 5–13
5–13 Forked Set Occurrence ..................................... 5–15
5–14 Bachman Diagram of a Many-to-Many Relationship Between Two
Types of Records . ........................................ 5–16
5–15 Many-to-Many Relationship Between Two Types of Records . ....... 5–17
5–16 Bachman Diagram of a Many-to-Many Relationship Between Records
of the Same Type . ........................................ 5–18
5–17 Current of PART_USES and PART_USED_ON . . . ............... 5–18
5–18 Retain PART_USES Currency ............................... 5–19
5–19 COMPONENT Is Connected to Both Set Types . . . ............... 5–19
5–20 Finding the Stool Legs While Keeping STOOL Current of
PART_USES ............................................ 5–20
5–21 Completed Bill of Materials . ................................ 5–20
5–22 Occurrence Diagram of a Many-to-Many Relationship Between
Records of the Same Type . . ................................ 5–21
5–23 Sample Parts Breakdown Report ............................. 5–21
5–24 One-to-Many Relationship Between Records of the Same Type ...... 5–22
5–25 Sample Data Prior to Update ................................ 5–23
5–26 Sample Data After Update . . ................................ 5–24
5–27 Database Relationships .................................... 5–25
5–28 Currency Status by Executable DML Statement . . ............... 5–30
5–29 Physical Representation of a Realm Without a RETAINING
Clause . ................................................ 5–31
5–30 Physical Representation of a Realm with a RETAINING Clause ..... 5–32
5–31 State of KEEPLIST-1 After Executing Line 000160............... 5–33
5–32 State of KEEPLIST-1 After Executing Lines 000190 and 000200 .... 5–33
5–33 Transactions and Quiet Points ............................... 5–34
6–1 Using the COMMIT Statement .............................. 6–4
6–2 Occurrences of the RESPONSIBLE_FOR Set Type ............... 6–5
6–3 Modifying Members of Sorted Sets ............................ 6–7
6–4 After Modifying MEMBER_B and Using RETAINING ............ 6–8
6–5 Occurrence Diagram Prior to RECONNECT .................... 6–9
6–6 Occurrence Diagram After RECONNECT ...................... 6–10
6–7 Results of an ERASE ALL . . ................................ 6–11
6–8 Results of an ERASE Record-Name (with Both OPTIONAL and
FIXED Retention Classes) . . ................................ 6–12
6–9 Record Locking . . . ........................................ 6–14
6–10 Using FIND NEXT and FETCH NEXT Loops ................... 6–15
7–1 Split Screen After FETCH FIRST PART USING PART_ID . . ....... 7–4
7–2 Split Screen After FETCH NEXT WITHIN PART_SUPPLY . ....... 7–5
7–3 Split Screen After MODIFY SUP_RATING ..................... 7–6
7–4 Split Screen After FETCH OWNER WITHIN VENDOR_SUPPLY .... 7–6
7–5 Split Screen After FETCH CURRENT PART RETAINING
PART_SUPPLY . . ........................................ 7–8
vii