File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-62
CREATE Guidelines

If FUP terminates because an error occurs while CREATE is automatically creating
alternate-key files, the primary-key file and any alternate-key files already created
are not deleted. You must purge these files manually.

CREATE cannot create SQL files that are not SQL object files. You must use
SQLCI CREATE instead.

To override the default SMF assignment on a CREATE command of a file on a
logical volume, use the CREATE command with the PHYSVOL option.

All partitions of a file are created with the same format version. For files that are
not sequenced, an independently created partition must have the same format as
all other partitions of the file.

For an enhanced key-sequenced file and a key-sequenced file with increased
limits, the SET PART command accepts a non-zero partial-key-value for the
first secondary partition. However, a subsequent CREATE command by the user
fails and the error ERR46 is returned.

Using the CREATE command, you can create:

128 partitions

Blocklength up to 32 KB

Recordlength up to 27,648

Primary keylength up to 2048

Primary keyoffset up to 27,647

Alternate key value up to 2048

Alternate keyoffset up to 27,647

Locklength up to maximum primary keylength for Format 2 key-sequenced
file

Using the CREATE command, you can create a queue file same as key-
sequenced file with increased limits.
Note. CREATE command fails for Format 1 LKS file, which has increased limits set using
SET command.