Directives
KEYED LOAD Load and Repair Keyed File
   
Format KEYED LOAD (chan,[KNO=num | name$])
 
Where:
chan Channel or logical file number of the file to be read/repaired.
nuame$ Name of the key (if assigned) to load. String expression.
num Number of the key to load. Integer >= 0.
   
Description This directive is used to rebuild the key tables of a file which is currently open on a channel. KEYED LOAD (chan) rebuilds all key trees. To rebuild a specific key chain, use the file access key value KNO=num | name$. KEYED LOAD will identify duplicate primary or unique keys.

The file does not have to be locked for KEYED LOAD to work. KEYED LOAD rebuilds the key chains within the file without using more disk space, while the file is in use, and while the file is being updated by others. KEYED LOAD is much faster than *UFAR in repairing key trees.

However, it performs much faster if the file is locked, and if there is sufficient ram available for its key block buffering operations. Also, KEYED LOAD will update the number of records for fixed length files if the file is locked.

Once the KEYED LOAD command is completed, TCB(67) will be set to one of the following values:

TCB(67) Contents
>= 0 Number retruned indicates the number of keys reloaded.
-1 A value of -1 indicates that a different number of keys were encountered on different key chains. This may or may not indicate that the file being re-loaded has physical damage that KEYED LOAD is unable to correct; i.e., the file can be reloaded on the fly while others are adding records, and therefore the number of keys on a given key chain may have changed while KEYED LOAD was working.
   
  If using PxPlus and reloading all keys on a VLR keyed file, the system will physically walk all page within the file physically to assure that their page headers are correct. Any invalid page header will be cleared and put back into the free space. This helps assure the integrity of the output file, guarantess recovery of lost space, and ultimately speeds up processing.

This enhanced reload algorithm is a +PxPlus Exclusive (build 9182)

*Note* KEYED LOAD reports invalid file type when used on Sort files. KEYED LOAD and will not operate on files opened in Read-Only mode.
Example ->open (1)"datafile.dat"
->keyed load (1)
Done - loaded key number 0 with 263 keys Done - loaded key number 1 with 263 keys Done - loaded key number 2 with 263 keys Done - loaded key number 3 with 263 keys Done - loaded key number 4 with 263 keys Done - loaded key number 5 with 263 keys