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 |
|---|---|---|---|---|---|
| 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. |
| QCB01 | Error | 21021 | -1013101L | "You do not have permission to drop this join index. %1" | You do not have permission to drop this join index. Click here for a list of possible parameters and odbc states. |
| QCB02 | Error | 21022 | -1013102L | "User name '%2' does not exist. %1" | The specified user does not exist. Click here for a list of possible parameters and odbc states. |
| QCB03 | Warning | 21026 | 1013103L | "JI MATCH E=%1;S=%2;TID=%3;NRows=%4;JID=%5;NTab=%6;Miss=%7;Data=%8" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays the scoring given to each table/join index matched. Click here for a list of possible parameters and odbc states. |
| QCB04 | Warning | 21027 | 1013104L | "JI NOMATCH - Entry=%1, Table=%2, Join=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join has not been selected. Click here for a list of possible parameters and odbc states. |
| QCB05 | Warning | 21028 | 1013105L | "JI MATCH COMPARING - E=%1, MP=%2, JID=%3, Name=%4" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join is being compared to the others. Click here for a list of possible parameters and odbc states. |