DDS for physical and logical files


REFACCPTH (Reference Access Path Definition) keyword--logical files only

Use this file-level keyword to specify that the access path information for this logical file is to be copied from another physical or logical file. The access path information includes key information, select and omit information, alternative collating sequence information, dynamic select information, and key sequencing information (specified in the FCFO, FIFO, LIFO, and UNIQUE keywords).

The format of the keyword is:

REFACCPTH([library-name/]database-file-name)

The name of the file defining the access path is the parameter value for the keyword.

The file containing the REFACCPTH keyword cannot contain key, select, or omit fields.

The record format(s) in the file you are defining can contain fewer or more fields than the record format(s) in the physical file on which this logical file is based.

If the file specified on the REFACCPTH keyword is a simple or multiple format logical file, it and the file containing the REFACCPTH keyword must have the same physical files specified in the same order on the PFILE keyword.

The REFACCPTH keyword is not allowed in join logical files. You can specify a join logical file as the parameter value on the REFACCPTH keyword only if all the following are true:

You cannot specify a Distributed Data Management (DDM) file on this keyword.

You cannot specify the REFACCPTH keyword with the DYNSLT, ALTSEQ, FCFO, FIFO, LIFO, or UNIQUE keywords.

Example:

The following example shows how to specify the REFACCPTH keyword.

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
00030A* ORDER HEADER LOGICAL FILE (ORDHDR11)
00040A                                      REFACCPTH(DSTLIB/ORDHDRL)
00050A          R ORDHDR                    PFILE(ORDHDRP)
     A


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