SST (Substring) Keyword for Physical and Logical Files--Examples

Figure 72 and Figure 73 show how to specify the SST keyword.

Figure 72 shows how to specify the SST keyword on a join logical file.

Figure 72. Specifying the SST Keyword on a Join Logical File

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A          R RECORD1                   JFILE(PF1 PF2)
A          J                           JOIN(1 2)
A                                      JFELD(CITY CITY)
A            ADDRESS                   JREF(2)
A            CITY               I      SST(ADDRESS 21 10)
A                                      JREF(2)
A            SYEAR              I      SST(SALESDATE 5)
A            NAME                      JREF(1)
A            CUSTNAME           I      SST(NAME 11 10) JREF(2)
A          K SYEAR
A

Figure 72 shows:

Figure 73 shows how to specify the SST keyword on a simple or multiple format logical file.

Figure 73. Specifying the SST Keyword on a Simple or Multiple Format Logical File

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A          R REC1                      PFILE(PFA)
A            LASTNAME           I      SST(NAME 10 10)
A          K LASTNAME
A

The LASTNAME field is a substring of NAME from PFA. The usage I in position 38 must be specified for SST fields in simple or multiple format logical files.