FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-182
SET Parameters for Files With Alternate-Key Fields
[ 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 in the range 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
files, you might leave files unsynchronized in rare circumstances. For
example, you could have two files pointing to the same alternate-key file
but only want updates from one of the two written to it.
The default is UPDATE.
Note. For information about null values, see the Enscribe Programmer’s Guide.
To Next Page
Loading...
Need help?
General