File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-16
ALTER Parameters for Files With Alternate-Key
Fields
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 ranging from 0 through 255). The default is NO NULL.
[ NO ] UNIQUE
specifies whether to set key-specifier as a unique key. The default is
NO UNIQUE.
[ NO ] UPDATE
specifies whether to set automatic updating 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 want to keep alternate-key files synchronized with
their main files, you sometimes might want to keep files unsynchronized.
For example, you might 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.
DELALTFILE key-file-number
deletes the reference to an alternate-key file but does not purge the file. The
alternate-key file must not be referenced by any existing key-specifier. After
you execute an ALTER command with this option, the remaining key-file numbers
and references to them are adjusted. The numbers begin with zero and are
contiguous (0,1, 2, and so on).
DELALTKEY key-specifier
deletes an alternate-key specification. You cannot access the file through
key-specifier after you execute this option. The key-specifier parameter is
a 2-byte value that you already specified (in the ALTKEY parameter) to identify the
alternate-key field. The value is passed to the KEYPOSITION procedure when it is
referenced by this key field.
Specify key-specifier as a one or two-character string in quotation marks:
"[c1]c2"
Or specify it as an integer from -32,768 through 32,767:
{ -32,768 : 32,767 }
You can use any characters for key-specifier except zero. If you omit c1, then
c1 is treated as a zero.
Note. For more information about null values, see the Enscribe Programmer’s
Guide.