Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1013055L | Error | 20625 | QCA55 | "ON_ERROR = 'CONTINUE' is valid only for a full-width INSERT. %1" | ON_ERROR = 'CONTINUE' is valid only for a full width insert. Click here for a list of possible parameters and odbc states. |
| -1013056L | Error | 20626 | QCA56 | "FILLER width must be greater than zero. %1" | FILLER width must be greater than zero. Click here for a list of possible parameters and odbc states. |
| -1013057L | Error | 20627 | QCA57 | "ASCII input column width must be greater than zero. %1" | ASCII input column width must be greater than zero. Click here for a list of possible parameters and odbc states. |
| -1013058L | Error | 20628 | QCA58 | "The row delimiter must be distinct from all column delimiters. %1" | The row delimiter cannot be the same as any column delimiter. Click here for a list of possible parameters and odbc states. |
| -1013059L | Error | 20629 | QCA59 | "The BLOCK SIZE option is not valid for a fixed-width input insert. %1" | You cannot specify BLOCK SIZE for a fixed-width input insert. Click here for a list of possible parameters and odbc states. |
| -1013060L | Error | 20630 | QCA60 | "The BLOCK FACTOR option is not valid for a variable width input insert. %1" | You cannot specify BLOCK FACTOR for a variable width input insert. Click here for a list of possible parameters and odbc states. |
| -1013061L | Error | 20631 | QCA61 | "Missing row delimiter detected during a row delimited insert. %1" | The input data is missing a row delimiter. Click here for a list of possible parameters and odbc states. |
| -1013062L | Error | 20632 | QCA62 | "Expected '%2' delimited column type on input, but encountered a row delimiter instead. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file. %1" | A row delimiter, rather than a column, was encountered during a LOAD. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file. Click here for a list of possible parameters and odbc states. |
| -1013063L | Error | 20633 | QCA63 | "Expected raw-data column type '%2' on input, but no input data exists. %1" | No data was found during a scan of an input file during insert. Click here for a list of possible parameters and odbc states. |
| -1013064L | Error | 20634 | QCA64 | "Row delimiter not seen during scan of input file. At least one of the input rows is missing a terminator. %1" | A row delimiter has been omitted from an input file. Click here for a list of possible parameters and odbc states. |
| -1013065L | Error | 20635 | QCA65 | "Row delimiter '%2' and column delimiter '%3' cannot be substrings of each other. %1" | Row and column delimiters cannot be substrings of each other. Click here for a list of possible parameters and odbc states. |
| -1013066L | Error | 20636 | QCA66 | "The %2 load option can be specified only once. %1" | The named load option can be specified only once per LOAD statement. Click here for a list of possible parameters and odbc states. |
| -1013067L | Error | 20637 | QCA67 | "Option CONVERSION ERROR must be OFF when IGNORE CONSTRAINT DATA VALUE or ALL is specified. %1" | When IGNORE CONSTRAINT DATA VALUE or ALL is given on a load statement, the database option CONVERSION ERROR must be off. Click here for a list of possible parameters and odbc states. |
| -1013068L | Error | 20638 | QCA68 | "Constraint '%2' violated: Invalid value for column '%3' in table '%4'. %1" | The Data being inserted or updated is invalid due to a column check constraint violation. Click here for a list of possible parameters and odbc states. |
| -1013070L | Error | 20640 | QCA70 | "Cannot specify check constraints off and ignore all, ignore check, log all or log check during load. %1" | when check constraints off is specified during load ignore all, ignore check, log all, log check are not available. Click here for a list of possible parameters and odbc states. |
| -1013071L | Error | 20641 | QCA71 | "Constraint '%2' violated: Invalid value in table '%3'. %1" | The Data being inserted or updated is invalid due to a table check constraint violation. Click here for a list of possible parameters and odbc states. |
| -1013077L | Error | 20647 | QCA77 | "ROW DELIMITED BY is valid only when all columns are delimited or ASCII fixed-width. %1" | ROW DELIMITED BY is valid only when all columns are delimited or ASCII fixed-width. You cannot use a row delimiter with PREFIX or BINARY columns. Click here for a list of possible parameters and odbc states. |
| -1013078L | Error | 20648 | QCA78 | "Insert Pass 1 CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| -1013079L | Error | 20649 | QCA79 | "Insert Pass 1 user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| -1013080L | Error | 20650 | QCA80 | "Insert Pass 1 system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |