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 |
|---|---|---|---|---|---|
| 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. |
| QCA85 | Error | 20655 | -1013085L | "Insert Commit user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA86 | Error | 20656 | -1013086L | "Insert Commit system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA87 | Error | 20657 | -1013087L | "Total Insert CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA88 | Error | 20658 | -1013088L | "Insert Total user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA89 | Error | 20659 | -1013089L | "Insert Total system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
| QCA90 | Error | 20979 | -1013090L | "Single or double quote mark cannot be the first character of column delimiter or row terminator with QUOTES option ON. %1" | Cannot use single or double quote mark for column/row delimiter with QUOTES option ON. Click here for a list of possible parameters and odbc states. |