FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-23
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 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-138
LOAD Creates a structured file from scratch 2-131
CONFIG[URE] Sets default options for the BUILDKEYRECORDS command 2-26
To Next Page
Loading...
