SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-38
SQL 9129
Cause. The row was not ordered by the value of the primary key.
Effect. The statement fails.
Recovery. Remove the SORTED option, or pass rows ordered by primary key value.
SQL 9130
Cause. The operation is not allowed if the table has referential constraints.
Effect. The operation is terminated.
Recovery. Use the FILEINFO command with the DETAIL option to determine the
names of the referential constraints associated with the table. Drop all of the referential
constraints and then reissue the command.
SQL 9131
Cause. As a result of mapping, the indicated source column had an associated target
column, but the current record ended before reaching that column. The target column
should have been set to its default value, but the target column did not have a default
value.
Column names of the form copy of SQL-column-name are used for a non-SQL file
when a DDL record is not specified.
Effect. The row is not written to the output file. If the error limit in the ALLOWERRORS
option is reached, the command terminates.
Recovery. Either put a value in the source column, or specify a default value for the
target column. Or ignore the error if data loss is acceptable.
9129 Row number value-1 has a key out of order.
9130 All referential constraints must be dropped from table
value-1 before performing the value-2 operation.
9131 Source row number value-1 has no value for column value-
3, and the corresponding target column does not have a
default value.
The source row length is value-4. (Column value-3 starts at
offset value-2.)