SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-31
SQL 9107
Cause. You attempted to use a PARTONLY or PARTOF option for writing data into, or
a PARTONLYIN option for reading data from, a relative or entry-sequenced file.
Effect. The command fails.
Recovery. Remove the PARTONLY, PARTONLYIN, or PARTOF option, and reissue
the command.
SQL 9108
Cause. You attempted to load an SQL table with indexes using the PARTONLY or
PARTOF option.
Effect. The LOAD command fails.
Recovery. Remove the PARTONLY and PARTOF options, and reissue the LOAD
command. Alternatively, drop all indexes, load the table, and then re-create the
indexes.
SQL 9109
Cause. You attempted to load an Enscribe file using the PARTONLY option without
specifying a primary partition.
Effect. The LOAD command fails.
Recovery. Add the PARTOF option to supply the name of the primary partition, and
reissue the LOAD command.
9107 A PARTONLY or PARTOF option can be used only with a key-
sequenced target, and a PARTONLYIN option can be used only
with a key-sequenced source.
9108 An SQL file with indexes cannot be loaded using PARTONLY
or PARTOF options.
9109 When loading an ENSCRIBE file with the PARTONLY option,
you must specify PARTOF to supply the name of the primary
partition.