HP Integrity NonStop J-Series - Manual (Page 108)

CREATING AND RUNNING A MULTIFILE APPLICATION
Associating and Linking Boxes
S5044-031
Employee Records
(All records qualify for
the access path) Dependent Records
(Records qualify for the access path
if they match an employee record)
Empnum . . . Emp-No . . .
0001 Jack Jones . . .
0002 Marge Martin
0003 Phil Smith
0004 Mark Monte
0006 Steven Myers
0007 Joe Lane
0008 Anne Lee
• • •
0001 01 Jane Jones
0001 02 Bill Jones
0001 03 Mark Jones
0002 01 Judy Martin
0004 01 Leslie Monte
0004 02 David Monte
0004 03 Sue Monte
0006 01 Liz Myers
0007 01 Lois Lane
0008 01 Tod Lee
0008 02 Steve Lee
• • •
• • •
• • •
• • •
• • •
• • •
• • •
• • •
• • •
• • •
• • •
• • •
• • •
A Dependent record with Emp-No = 0005 does not qualify for the application access
path because a matching Employee record with Empnum = 0005 does not exist.
Legend
The Employee record with Empnum = 0003 qualifies for the application access path
even though a matching Dependent record does not exist.
1
2
1
2
Figure 5-12. Qualified Records for a Tree Structure
With Two Boxes
The access path established for an application also affects the
way that you can perform delete and update operations on records
for these boxes, for example:
• If you update a parent record and change the value of its join
field, the child record that previously matched the updated
record no longer qualifies for the application-access path.
5-24