SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-29
LOAD Command
ISLACK percent
(for loading only files or tables with key-sequenced file organization) specifies the
minimum percentage of space to be left in index blocks for future insertions.
Specify percent as a numeric literal from 0 through 99. If space is not available
when an insertion is made, a block split occurs.
If you omit this option, LOAD uses the SLACK percent value.
SLACK percent
for key-sequenced targets only, specifies the minimum percentage of space to be
left in both index blocks and data blocks for future insertions. Specify percent as a
numeric literal from 0 through 99. If space is not available when an insertion is
made, a block split occurs.
If you omit this option, LOAD leaves 15 percent slack space in both the data and
index blocks.
If you specify DSLACK, ISLACK, and SLACK, the LOAD utility uses the DSLACK
value for data blocks and the ISLACK value for index blocks. The SLACK value is
ignored.
move-option
specifies names of elements related to the table or file and how to map source
names to different target names.
SOURCEDICT dictionary-name
identifies the subvolume containing the DDL dictionary that contains the record or
DEF definition for an Enscribe input file. dictionary-name is a Guardian
subvolume name.
If you omit the SOURCEDICT option, LOAD assumes that the DDL dictionary
resides on the current default subvolume.
SOURCEREC ddl-record-name
identifies the name of the DDL record or DEF definition for an Enscribe input file.
ddl-record-name must be a valid DDL data name.
If you omit the SOURCEREC option, LOAD assumes that fields in the file occur in
the same order as the columns in the target table and that all variable-length
character fields are expanded to the maximum length and padded with blanks. For
information about how LOAD converts other data types if they are not explicitly
defined, see the Data type compatibility and field conversions item under
Considerations—LOAD on page L-33.