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 |
|---|---|---|---|---|---|
| -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. |
| -1013081L | Error | 20651 | QCA81 | "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. |
| -1013082L | Error | 20652 | QCA82 | "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. |
| -1013083L | Error | 20653 | QCA83 | "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. |
| -1013084L | Error | 20654 | QCA84 | "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. |
| -1013085L | Error | 20655 | QCA85 | "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. |
| -1013086L | Error | 20656 | QCA86 | "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. |
| -1013087L | Error | 20657 | QCA87 | "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. |
| -1013088L | Error | 20658 | QCA88 | "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. |
| -1013089L | Error | 20659 | QCA89 | "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. |
| -1013090L | Error | 20979 | QCA90 | "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. |
| -1013091L | Error | 20983 | QCA91 | "Column pairs %2=%3 could not be matched. %1" | The columns specified in CREATE JOIN could not be matched in the tables specified. Click here for a list of possible parameters and odbc states. |
| -1013092L | Error | 20984 | QCA92 | "The MONITOR for this database, connection and buffer cache already exists. %1" | A monitor has already been started for this database, connection and buffer cache. Click here for a list of possible parameters and odbc states. |
| 1013093L | Warning | 20985 | 00A93 | "Insert started: %1\n" | This is an informational message displayed during insert. Click here for a list of possible parameters and odbc states. |
| -1013094L | Error | 20986 | QCA94 | "A matching column can not be found for the foreign keys in %2. %1" | This message is returned during CREATE JOIN INDEX when the KEY options is used. Be sure that the tables specified in the join have foreign keys pointing to the table in the message. Click here for a list of possible parameters and odbc states. |