JREF (Join Reference) Keyword for Logical Files Only--Examples

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).