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

Page 63
Image 63
IBM SC41-5210-04 manual Incorrect method