Describing Access Paths for Logical Files

The access path for a logical file record format can be specified in one of the following ways:

1. Keyed sequence access path specification. Specify key fields after the last record or field level specification. The key field names must be in the record format. For join logical files, the key fields must come from the first, or primary, physical file.

   
   

   |...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 A R CUSRCD PFILE(CUSMSTP) A K ARBAL A K CRDLMT A

2. Encoded vector access path specification. You define the encoded vector access path with the SQL CREATE INDEX statement.
3. Arrival sequence access path specification. Specify no key fields. You can specify only one physical file on the PFILE keyword (and only one of the physical file's members when you add the logical file member).

   
   

   |...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 A R CUSRCD PFILE(CUSMSTP)

4. Previously defined keyed-sequence access path specification (for simple and multiple format logical files only). Specify the REFACCPTH keyword at the file level to identify a previously created database file whose access path and select/omit specifications are to be copied to this logical file. You cannot specify individual key or select/omit fields with the REFACCPTH keyword.

   Note:

   Even though the specified file's access path specifications are used, the system determines which file's access path, if any, will actually be shared. The system always tries to share access paths, regardless of whether the REFACCPTH keyword is used.

   
   

   |...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 REFACCPTH(DSTPRODLIB/ORDHDRL) A R CUSRCD PFILE(CUSMSTP)

When you define a record format for a logical file that shares key field specifications of another file's access path (using the DDS keyword, REFACCPTH), you can use any fields from the associated physical file record format. These fields do not have to be used in the file that describes the access path. However, all key and select/omit fields used in the file that describes the access path must be used in the new record format.