File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-191
SET Guidelines

Using SET 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

SET PART command accepts secondary-partition-num up to 127.

SET PART command accepts a non zero partial-key-value for first
secondary partition. However, a subsequent CREATE command issued by the user
fails and the error ERR46 is returned. The error is displayed only if the file type is
key-sequenced and number of secondary partition is greater than 15.

SET LIKE command accepts filename as key-sequenced file with increased limits.

SET ALTKEY command accepts key-offset up to 27,647.

SET ALTKEY command accepts key-length in the following manner:

For unique alternate keys, the maximum length is 2046 bytes.

For insertion-ordered duplicate alternate keys, the maximum length is (2038-
primary-key length).

For primary-key-ordered duplicate alternate keys, the maximum length is
(2046- primary-key length).

Using SET command, you can create a queue file same as key-sequenced file with
increased limits.
Table 2-3 summarizes the upward rounding that can occur at file creation. Block and
buffer sizes are in bytes, and extent sizes are in pages. (The default extent size is one
Note. 1.SET EXT command accepts primary-extent-size and secondary-
extent-size.
a. If the primary-extent-size is less than 140, DP2 creates primary
partition with primary extents as 140 for key-sequenced file with increased
limits (EKS file with increased limits).
b. If the primary-extent-size is less than (224, 16), DP2 creates the
primary partition with primary and secondary extents as (224, 16) for key-
sequenced file with increased limits having blocklength=32,768.