SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-33
SQL 9113
Cause. For a COPY, LOAD, APPEND, or APPENDRESTART command, the source
row violated constraints on the target SQL table.
Effect. The row is not written to the output file. If the error limit in the ALLOWERRORS
option is reached, the command terminates.
Recovery. Correct the source data.
SQL 9114
Cause. The source row had invalid (possibly nonnumeric) data.
Effect. The row is not written to the output file. If the error limit in the ALLOWERRORS
option is reached, the command terminates.
Recovery. Correct the source data.
SQL 9115
Cause. The COPY, LOAD, APPEND, or APPENDRESTART command was specified
with the REPLACE SPACES WITH DEFAULTS option. A numeric source column was
filled with spaces, but the corresponding 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 correct the source data, or re-create the target table to include a
default value for the corresponding target column and reissue the command or, if data
loss is acceptable, ignore the error.
9113 The source row number value-1 violates constraint value-
2 for the target table.
9114 Row number value-1 in the source file, where the first
record is number 1, contains invalid data.
9115 Source row number value-1 contains spaces in the numeric
column value-3, but the corresponding target column does not
have a default value.
(Column value-3 starts at offset value-2.)