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

Figure 62 and Figure 63 show how to specify the JREF keyword.

Figure 62. 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 62, 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 63 shows how to use the file reference numbers to specify JREF.

Figure 63. 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 63 is equivalent to Figure 62. In Figure 63, 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).


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]