IBM ISERIES SC41-5210-04 - Manual (Page 63)

Incorrect method:
On the Specify File Selections display, type the CUSTOMER file first, and specify the file ID as A. Type the
ITEM file second (file C), and the PURCHASE file third (file B), which is in the opposite order from the correct
method. Note that each file has the same file ID as before. Specify the join type and join tests the same
as before. This method does not follow the secondary file sequence rule because file
C is not connected
by a join test to the file (
A) listed above it.
Chapter 4. Specifying and selecting files for a Query for iSeries query 51