File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-188
SET Parameters for Files With Alternate-Key Fields
FILE key-file-number
sets the key-file number for key-specifier. Specify key-file-number
as an integer from 0 through 99. ALTFILE create-param relates this
number to an actual file. The default is zero.
[ NO ] INSERTIONORDER
specifies whether or not insertion-ordered alternate-key sequencing is to
be used. The default is NO INSERTIONORDER. The default specifies
alternate key records of files with duplicate key values ordered 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 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 key length for key-specifier. You must specify a KEYLEN to
create a key-sequenced file, or the creation attempt fails.
KEYOFF key-offset
sets the key offset for key-specifier. The default setting for
key-offset is zero.
NO NULL | NULL null-value
specifies whether or not a null value is set for key-specifier. If a value
is specified, null-value must be an ASCII character in quotation marks
or an integer ranging from 0 through 255. The default is NO NULL.
[ NO ] UNIQUE
specifies whether or not key-specifier is set as a unique key. The
default is NO UNIQUE.
[ NO ] UPDATE
specifies whether or not automatic updating is set for the alternate-key file
represented by key-specifier.
The NO UPDATE option prevents the file system from automatically
updating the specified alternate-key file when you write to the main file.
Although you usually keep alternate-key files synchronized with their main
Note. For information about null values, see the Enscribe Programmer’s Guide.