File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-146
LOADALTFILE Example

A duplicate key in an alternate-key file with the UNIQUE attribute causes
LOADALTFILE to fail and display file-system error 71 (duplicate record).

LOADALTFILE does not always generate alternate-key file records or display
explanatory messages if either of these statements apply:

The full length of the alternate-key field is not contained in a specific primary
record.

A null value was specified for the key, and the field contains only the null value.

LOADALTFILE cannot work with SQL files. You must use SQLCI LOAD.

LOADALTFILE command operates on key-sequenced file with increased limits.
LOADALTFILE Example
This command generates alternate-key records from the primary file (KSFILE) and
loads the records into the alternate-key file with key-file-number 0. A minimum of 10
percent slack space remains in the data blocks of the alternate-key file:
-LOADALTFILE 0, KSFILE, DSLACK 10
Commands Related to LOADALTFILE
OBEY
Reads commands from the specified file and executes them.
After FUP reads an EOF in the command file, it returns you to the FUP command
prompt. If the command file causes a change in status (by executing VOLUME or
CONFIGURE commands), the new status remains enabled after the completion of the
OBEY command.
filename
is the name of the file containing the commands that you want to execute. The
default volume and subvolume for the file (and all files in the command file) are
derived using the standard FUP rules for defaulting any files enabled during the
execution of the command.
COMMAND Function Page
LOAD Creates a structured file from scratch 2-136
BUILDKEYRECORDS Creates alternate-key file records 2-23
OBEY filename