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 |
|---|---|---|---|---|---|
| QDC78 | Error | 21124 | -1000296L | " Invalid load specification for LOAD ... FORMAT BCP. %1" | The user specified a load specification that is not supported with FORMAT BCP option. Click here for a list of possible parameters and odbc states. |
| QDC79 | Error | 21152 | -1000299L | " Partition key of %2 is unsupported. %1" | Partiiton key of LOB/CLOB/char/varchar/binary/varbinary over 255 is not supported. Click here for a list of possible parameters and odbc states. |
| QDC80 | Error | 21153 | -1000300L | " Table that participates in a join index cannot be partitioned. %1" | A partitioned table cannot participate in join. Click here for a list of possible parameters and odbc states. |
| QDC81 | Error | 21154 | -1000301L | " Join index cannot be created on a partitioned table. %1" | Join index cannot be created on a partitioned table. Click here for a list of possible parameters and odbc states. |
| QDC82 | Error | 21155 | -1000302L | " Exceed maximum number of partitions. %1" | Exceed maximum number of partitions. Click here for a list of possible parameters and odbc states. |
| QDC83 | Error | 21156 | -1000303L | " Object %2 not usable in current context. %1" | Table of TBLTYP_PARTITION type cannot be used. Click here for a list of possible parameters and odbc states. |
| QDC84 | Error | 21157 | -1000304L | " Cannot drop a partition key column. %1" | Can not drop a partition key column. Click here for a list of possible parameters and odbc states. |
| QDC85 | Error | 21158 | -1000305L | " Allocation failure. %1" | DBCC allocation failure Click here for a list of possible parameters and odbc states. |
| QDC86 | Error | 21164 | -1000306L | " Different DB space, cannot merge partition %2 into %3. %1" | Cannot merge Partition partition name 1 into Partition partition name2 in different dbspaces Click here for a list of possible parameters and odbc states. |
| QDC87 | Error | 21165 | -1000307L | " No data move is allowed, cannot split partition %2. %1" | Cannot split Partition partition name 1 into Partition partition name2 and Partition name3 as the split requires to move data. Click here for a list of possible parameters and odbc states. |
| QDC88 | Error | 21166 | -1000308L | " Boundary value for the partition %2 cannot be changed. %1" | Cannot change boundary value for split Partition partition name 1 into (partition-decl-1, partition-decl-2). Boundary value for partition-decl-2 must be the same as partition name 1. Click here for a list of possible parameters and odbc states. |
| QDC89 | Error | 21167 | -1000309L | " Not all partitions in each column are in same dbspace, cannot unpartition %2. %1" | Cannot alter partitioned table to an unpartitioned table as not all partitions in each column are in the same dbspace. Click here for a list of possible parameters and odbc states. |
| QDC90 | Error | 21168 | -1000310L | " 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. |
| QDC91 | Error | 21169 | -1000311L | " '%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. |
| QDC92 | Error | 21170 | -1000312L | " 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. |
| QDC93 | Error | 21171 | -1000313L | " 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. |
| QDC94 | Error | 21173 | -1000314L | " 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. |
| QDC95 | Error | 21174 | -1000315L | " 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. |
| QDC96 | Error | 21175 | -1000316L | "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. |
| QDC97 | Error | 21181 | -1000317L | "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. |