Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.
SQL State | Msg Type | Number | SQL Code | Message | Possible Cause |
---|---|---|---|---|---|
QCA54 | Error | 20624 | -1013054L | "Delimiter '%2' must be 1 to %3 characters in length. %1" | The row or column delimiter in a LOAD statement must be 1-4 characters. Click here for a list of possible parameters and odbc states. |
QCA55 | Error | 20625 | -1013055L | "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. |
QCA56 | Error | 20626 | -1013056L | "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. |
QCA57 | Error | 20627 | -1013057L | "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. |
QCA58 | Error | 20628 | -1013058L | "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. |
QCA59 | Error | 20629 | -1013059L | "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. |
QCA60 | Error | 20630 | -1013060L | "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. |
QCA61 | Error | 20631 | -1013061L | "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. |
QCA62 | Error | 20632 | -1013062L | "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. |
QCA63 | Error | 20633 | -1013063L | "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. |
QCA64 | Error | 20634 | -1013064L | "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. |
QCA65 | Error | 20635 | -1013065L | "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. |
QCA66 | Error | 20636 | -1013066L | "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. |
QCA67 | Error | 20637 | -1013067L | "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. |
QCA68 | Error | 20638 | -1013068L | "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. |
QCA70 | Error | 20640 | -1013070L | "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. |
QCA71 | Error | 20641 | -1013071L | "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. |
QCA77 | Error | 20647 | -1013077L | "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. |
QCA78 | Error | 20648 | -1013078L | "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. |
QCA79 | Error | 20649 | -1013079L | "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. |