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 |
|---|---|---|---|---|---|
| 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. |
| QCA91 | Error | 20983 | -1013091L | "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. |
| QCA92 | Error | 20984 | -1013092L | "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. |
| QCA94 | Error | 20986 | -1013094L | "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. |
| QCA95 | Error | 20987 | -1013095L | "CREATE JOIN does not support joining joins. %1" | This message is returned during CREATE JOIN INDEX when the left hand side and right hand side of a 'FULL OUTER JOIN' keyword set are both joins ie (A FOJ B) FOJ (C FOJ D) the join of a-b is being joined to c-d. Click here for a list of possible parameters and odbc states. |
| QCA96 | Error | 20988 | -1013096L | "Index %2 could not be created. The datatype does not support an index of %3. %1" | You cannot create an index of the type specified for the column's datatype. Click here for a list of possible parameters and odbc states. |
| QCA97 | Error | 21018 | -1013097L | "Join Index %2 not unique. %1" | You have attempted to create a join index with a name of an existing join index Click here for a list of possible parameters and odbc states. |
| QCA98 | Error | 21004 | -1013098L | " The foreign key %2 participates in join %3 and can not be ALTERed. %1" | This message is returned during ALTER when a foreign key that is about to be altered, participates in the join of two tables. Click here for a list of possible parameters and odbc states. |
| QCA99 | Error | 21019 | -1013099L | "Join Indexes do not support the multipart foreign key found in table %2. %1" | You have attempted to create a joined index with a multipart foreign key. Click here for a list of possible parameters and odbc states. |
| QCB00 | Error | 21020 | -1013100L | "The ON keyword cannot be used in a NATURAL join. %1" | The ON keyword cannot be used in a NATURAL join. Click here for a list of possible parameters and odbc states. |