FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-14
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 in the range 0 through 255. 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 key length for key-specifier. To create a key-sequenced file,
you must specify a KEYLEN, or the creation attempt fails.
KEYOFF key-offset
sets the key offset for key-specifier. The default is zero.
NO NULL | NULL null-value
specifies whether to set a null value 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.
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.
Note. For more information about null values, see the Enscribe Programmer’s
Guide.
To Next Page
Loading...
Need help?
General