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 |
|---|---|---|---|---|---|
| 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. |
| QCA80 | Error | 20650 | -1013080L | "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. |
| QCA81 | Error | 20651 | -1013081L | "Insert Pass 2 CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA82 | Error | 20652 | -1013082L | "Insert Pass 2 user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA83 | Error | 20653 | -1013083L | "Insert Pass 2 system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA84 | Error | 20654 | -1013084L | "Insert Commit CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |