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 |
|---|---|---|---|---|---|
| -1000310L | Error | 21168 | QDC90 | " Cannot truncate table partition on a non-partitioned table %2. %1" | Cannot truncate table partition on a non-partitioned table. Click here for a list of possible parameters and odbc states. |
| -1000311L | Error | 21169 | QDC91 | " '%2' is not an IQ DBSPACE. %1" | Specified dbspace does not exist or is a catalog dbspace. Click here for a list of possible parameters and odbc states. |
| -1000312L | Error | 21170 | QDC92 | " ALTER INDEX MOVE can not move FP indexes. Command failed for %2. Use ALTER TABLE MOVE COLUMN instead. %1" | ALTER INDEX MOVE command does not move FP indexes. Use ALTER TABLE MOVE COLUMN instead. Click here for a list of possible parameters and odbc states. |
| -1000313L | Error | 21171 | QDC93 | " ALTER INDEX MOVE not allowed on components of a join index. Command failed for %2. %1" | ALTER INDEX MOVE command does not move link indexes. Click here for a list of possible parameters and odbc states. |
| -1000314L | Error | 21173 | QDC94 | " All rows must be in the first partition. %1" | Cannot alter unpartitioned table to a partitioned table as not all rows in the first partition. Click here for a list of possible parameters and odbc states. |
| -1000315L | Error | 21174 | QDC95 | " Cannot drop the last partition of a partitioned table. %1" | Cannot drop the last partition of a partitioned table. Click here for a list of possible parameters and odbc states. |
| -1000316L | Error | 21175 | QDC96 | "The NoExec option is set. The current operation will be rolled back. %1" | Certain operations will not be allowed whenever the NoExec option is set. They are: Alter table Split Partition & Alter Table Partition Click here for a list of possible parameters and odbc states. |
| -1000317L | Error | 21181 | QDC97 | "The current operation is not allowed on RO partition. %1" | Alter table drop/split/merge on a RO partition is not allowed. Click here for a list of possible parameters and odbc states. |
| -1000318L | Error | 21182 | QDC98 | "Unexpected type encountered for column '%2'. %1" | Parse tree contains an expected column type. Click here for a list of possible parameters and odbc states. |
| -1000319L | Error | 21185 | QDC99 | "Server (%2) is no longer a Multiplex coordinator. %1" | Specified server is no longer a Multiplex coordinator. Click here for a list of possible parameters and odbc states. |
| -1000320L | Error | 21189 | QDD00 | "Table with table id %2 no longer exists. %1" | There is no table with the given table id. It would have been dropped. Click here for a list of possible parameters and odbc states. |
| -1000321L | Error | 22006 | QDB85 | "dropleaks is not allowed in multiplex mode. %1" | Dropleaks require server to be started in simplex configuration Click here for a list of possible parameters and odbc states. |
| -1000322L | Error | 22007 | QDB86 | "Use CREATE DBSPACE USING FILE syntax for creating IQ dbspaces. %1" | In Atomic IQ dbspaces can be created using the FILE Syntax for create dbspace. Old pre-atomic syntax can be used to create catalog store dbspaces only. Click here for a list of possible parameters and odbc states. |
| -1000324L | Error | 21193 | QDD03 | "Maximum secondary node license limit reached. Cannot add new secondary node. %1" | New secondary node cannot be added since the license limit for adding a new secondary node has been reached. Click here for a list of possible parameters and odbc states. |
| -1000325L | Error | 21194 | QDD04 | "%2 node cannot be made a failover node. %1" | An excluded or coordinator node cannot be made a failover node. Click here for a list of possible parameters and odbc states. |
| -1000326L | Error | 21195 | QDD05 | "%2 of Coordinator node cannot be changed. %1" | ROLE or STATUS of Coordinator node cannot be changed. Click here for a list of possible parameters and odbc states. |
| -1000327L | Error | 21196 | QDD06 | "Failover node cannot be Excluded. %1" | A designated failover node cannot be Excluded. Click here for a list of possible parameters and odbc states. |
| -1000328L | Error | 21197 | QDD07 | "%2 node cannot be dropped. %1" | A Coordinator or a Failover node cannot be dropped from the multiplex configuration. Click here for a list of possible parameters and odbc states. |
| -1000329L | Error | 21198 | QDD02 | "The move target %2 is already in the specified dbspace. %1" | The move target for alter table or alter index is already in the specified dbspace. Click here for a list of possible parameters and odbc states. |
| -1000330L | Error | 21199 | QDD17 | "Default value %2 cannot be used as a LOAD default value. %1" | Specified default value cannot be used as a LOAD default value. Click here for a list of possible parameters and odbc states. |