Using existing access path specifications

 

You can use the Reference Access Path Definition (REFACCPTH) DDS keyword to copy another file's access path specifications. After you create the file, the system determines which access path to share.

The file using the REFACCPTH keyword does not necessarily share the access path of the file specified in the REFACCPTH keyword. The REFACCPTH keyword is used to only reduce the number of DDS statements that must be specified. That is, rather than code the key field specifications for the file, you can specify the REFACCPTH keyword. When the file is created, the system copies the key field and select/omit specifications from the file specified on the REFACCPTH keyword to the file being created.

 

Parent topic:

Describing access paths for database files