File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-15
ALTER Parameters for Files With Alternate-Key
Fields
You can use any characters for key-specifier except zero. If you omit c1,
then c1 is treated as a zero.
altkey-param
specifies attributes of the alternate-key file.
FILE key-file-number
sets the key-file number for key-specifier. Specify key-file-number
as an integer ranging from 0 through 99. This number is related to an
actual file by the ALTFILE create-param. The default
key-file-number is zero.
[ NO ] INSERTIONORDER
specifies whether to use insertion-ordered alternate-key sequencing. The
default, NO INSERTIONORDER, specifies to order alternate key records
of files with duplicate key values by their primary key sequence and not
their order of insertion.
An insertion-ordered alternate key cannot share an alternate-key file with
other keys of different lengths or with other keys that are not insertion
ordered.
All the nonunique alternate keys of a file must have the same duplicate-key
ordering attribute. A file with this specification must not have both insertion-
ordered alternate keys and standard (duplicate ordering by primary key)
nonunique alternate keys.
KEYLEN key-length
sets the primary key-length. Specify key-length as an integer ranging
from 1 through 255 and 2048 (for key-sequenced with increased limits). To
create key-sequenced file structures, you must specify KEYLEN, or the
creation attempt fails.
KEYOFF key-offset
sets the primary key-offset. Specify key-offset as an integer ranging
from 0 through 2034 and 27647 (for key-sequenced with increased limits).
The default setting for key-offset is 0.
Note. If you add a new key specifier that references an undefined key-file number,
you must include the ALTFILE option to define the alternate-key file.