SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-35
table. If the error is related to source data, correct the source data and restart the
command.
SQL 9120
Cause. During execution of a LOAD, APPEND, or APPENDRESTART command for a
key-sequenced target table, a row that contained a duplicate primary-key value was
rejected. This error can be caused by using different collations for the source and
target columns.
Effect. The row is not written to the output file. If the error limit in the ALLOWERRORS
option is reached, the command is terminated.
Recovery. Consider using the same collation for the source and target columns, or
modify the duplicate key value and insert the row after the command finishes.
SQL 9121
Cause. During execution of a LOAD, APPEND, or APPENDRESTART command
using the SORTED option with a key-sequenced target, a row was rejected because
the primary key was out of order. This error can be caused by using different collations
for the source and target columns.
Effect. The row is not written to the output file. If the error limit in the ALLOWERRORS
option is reached, the command is terminated.
Recovery. Consider using the same collations for the source and target columns, or
insert the row after the command finishes.
SQL 9122
Cause. The version incompatibility could have been caused by incompatible software,
objects, nodes, and so forth.
Effect. The command terminates.
Recovery. Solve the version incompatibility first, and rerun the command.
9120 A duplicate key encountered during a write operation to
table value-1 has been ignored.
9121 The following row was not loaded into table value-1
because the primary key is out of order.
9122 Incompatible versions between source and target. It
could be caused by incompatible software, objects, systems,
and so forth.