File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-21
ALTER Examples

If the extent sizes of a secondary partition are altered, this warning message
appears:
USING SPECIFIED EXTENT SIZES: USER MUST ENSURE
CONSISTENT PARTITIONS

The ALTER command cannot handle SQL files that are not SQL object files. To do
this, you must use SQLCI TABLE and SQLCI INDEX.

The ALTER command returns error 197 (an SQL error has occurred) against
SQL-compiled objects.

All partitions of a file are created with the same format version. For files that are
not key-sequenced, a partition created independently must have the same format
as all other partitions of the file.

ALTER command with filename as primary partition of an enhanced key-
sequenced file used with alter-option MAX EXTENT and PARTONLY option is
executed, but the maximum extents of the primary partition do not change.

ALTER command with filename accepts sec-partition-num up to 127.

ALTER command when executed with filename as primary partition of an EKS
file with increased limits and an alter-option MAX EXTENT with PARTONLY option,
the maximum extents of the primary partition do not change.

ALTER command when executed with filename as primary partition of a key-
sequenced file with increased limits and an alter-option ALTKEY, accepts key-
length and key-offset with increased limits.

ALTER command when executed with filename as primary partition of a key-
sequenced file with increased limits and an alter-option LOCKLENGTH, accepts
locklength up to maximum primary keylength.

ALTER command fails for Format 1 LKS file when alter-option like ALTKEY and
LOCKLENGTH are issued with increased limits.
ALTER Examples

To assign file code 10 to MYFILE1:
-ALTER MYFILE1, CODE 10

To cause the file label for MYFILE2 to be updated whenever the file control block
(FCB) changes:
-ALTER MYFILE2, REFRESH
Caution. If you use the ALTER command to change a partition to a different format from the
rest of the partitions, the file system reports errors. FUP does not check for such errors.