File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-25
BUILDKEYRECORDS Example

BUILDKEYRECORDS honors any NULL specification defined for a key field.
Alternate-key records are not generated for any fields that consist only of a null
character.

BUILDKEYRECORDS ignores NO UPDATE specifications.

BUILDKEYRECORDS ignores UNIQUE specifications. Duplicate unique-key
values are detected when the LOADALTFILE command loads the alternate-key
file.

When alternate key records are not built because the full alternate key does not
exist within the primary record, this message appears:
nnn RECORDS CONTAIN INCOMPLETE ALTERNATE KEY FIELDS
(ALTERNATE KEY RECORDS NOT GENERATED)

BUILDKEYRECORDS cannot handle SQL files.

BUILDKEYRECORDS command operates on key-sequenced file with increased
limits.
BUILDKEYRECORDS Example
To generate the alternate-key records for MYFILE using key specifications “ab” and
“cd”, and write the alternate-key records to $TAPE:
-BUILDKEYRECORDS MYFILE, $TAPE, ("ab","cd")
Commands Related to BUILDKEYRECORDS
COMMAND Function Page
LOADALTFILE Creates an alternate-key file from a primary file 2-144
LOAD Creates a structured file from scratch 2-136
CONFIG[URE] Sets default options for the BUILDKEYRECORDS command 2-28