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

CREATING AND RUNNING A MULTIFILE APPLICATION
Associating and Linking Boxes
S5044-034
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 Depends-Box record with Emp-No = 0005 does not qualify for the access path.
Legend
Empnum . . .
0001 Jack Jones . . .
0002 Marge Martin
0003 Phil Smith
0004 Mark Monte
0006 Steven Myers
0007 Joe Lane
0008 Anne Lee
Empnum . . .
0001 A3
0002 A4
0003 B1
0004 B2
0006 B9
0008 C1
A3 Great Deal
A4 New Stuff
B1 Fine Thing
B2 Good Rates
C1 Okay Deal
1
2
3
1
2
3
The following Empcov-Box record does not qualify for the application access path because its
join field value (0005) does not match an Employ-Box record: 0005 B3.
Since the record 0005 B3 does not qualify for the application access path, the following
matching Cov Box record also does not qualify: B3 Cheap Rates.
Employ-Box Records
(All qualify for the access path) Depend-Box Records
(Qualify for the access path if they match an
Emp-Box record)
Employ-Box Records
(All qualify for the access path) Empcov-Box Records
(Qualify for the access path if
they match an employ-box
record) Cov-Box Records
(Qualify for the access path if
they match a qualified record
from Empcov-Box)
Figure 5-15. Qualified Records for an Application With a
Three-Level Tree Structure
5-29