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 |
|---|---|---|---|---|---|
| -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. |
| -1000331L | Error | 21204 | QDD19 | "The requested FP style (%1) for %2 cannot be rebuilt. It will be rebuilt as %3." | The requested FP style cannot be rebuilt. Increase main cache or set FP_Lookup_Size_PPM to a higher percentage for 3-byte FP. Click here for a list of possible parameters and odbc states. |
| -1000332L | Error | 21206 | QDD20 | "Odd length of binary data value detected on column %2 - %1" | When loading hexadicimal data into BLOB, the total number of nibbles has to be an even number. If an odd number is detected, the load engine will rollback. This restriction does not apply to binary and varbinary data type. Click here for a list of possible parameters and odbc states. |