Figure 55 and Figure 56 show how to specify the JREF keyword.
Figure 55. Specifying the JREF Keyword (Example 1)
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 00010A R JOINREC JFILE(PFA PFB PFC) 00020A : 00030A : 00040A : 00050A NAME JREF(PFB) A
In Figure 55, the JREF keyword is specified with the file name, and NAME occurs in both PFA and PFB. Specifying JREF (PFB) associates this field with PFB.
Figure 56 shows how to use the file reference numbers to specify JREF.
Figure 56. Specifying the JREF Keyword (Example 2)
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 00010A R JOINREC JFILE(PFA PFB PFC) 00020A : 00030A : 00040A : 00050A NAME JREF(2) A
Figure 56 is equivalent to Figure 55. In Figure 56, NAME occurs in both PFA and PFB. Specifying JREF(2) associates this field with PFB (the second of the physical files specified on the JFILE keyword).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.