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 |
|---|---|---|---|---|---|
| QDC69 | Error | 20036 | -1000287L | "Invalid table argument %2 to sp_iq_reset_identity, Table cannot be a JVT. %1" | Tables of type JVT are not allowed as arguments to the stored procedure sp_iq_reset_identity Click here for a list of possible parameters and odbc states. |
| QDC70 | Error | 20037 | -1000288L | "Invalid table argument %2 for set option 'identity_insert', Table cannot be a JVT. %1" | Tables of type JVT are not allowed as a value for the set option 'identity_insert' Click here for a list of possible parameters and odbc states. |
| QDC71 | Error | 20038 | -1000289L | "Invalid table argument %2 for set option 'identity_insert', Table must be an IQ table. %1" | Only IQ tables are allowed as an argument value to the set option 'identity_insert' Click here for a list of possible parameters and odbc states. |
| QDC72 | Error | 20039 | -1000290L | "Invalid table argument %2 for stored procedure sp_iq_reset_identity, Table must be an IQ Table. %1" | Only IQ tables are allowed as a table argument to the stored procedure sp_iq_reset_identity Click here for a list of possible parameters and odbc states. |
| QDC73 | Error | 20041 | -1000291L | "You do not have insert permission on table %2. %1" | You cannot set the option 'identity_insert' to a table for which you do not have insert permission Click here for a list of possible parameters and odbc states. |
| QDC74 | Error | 20474 | -1000292L | "Invalid use of set option 'identity insert'. Table %2 does not have an Identity/Autoincrement Column. %1" | the set option 'identity insert' cannot be used on a table without an Identity/Autoincrement Column. Click here for a list of possible parameters and odbc states. |
| QDC75 | Error | 20644 | -1000293L | "Cannot insert or update Column %2: set option 'identity_insert' to the specific table name containing the identity column to be modified. %1" | set option 'identity_insert' must be set to the specific table for which you want to insert or update an Identity column. To turn it on use set identity_insert <table_name> Click here for a list of possible parameters and odbc states. |
| QDC76 | Error | 20645 | -1000294L | "Cannot set 'identity_insert', it is already on for a different table. %1" | the set option 'identity_insert' can only be set for one table at a time. To set it for a different table, first turn it off using 'set identity_insert '' ' then set it to the desired table. Click here for a list of possible parameters and odbc states. |
| QDC77 | Error | 20646 | -1000295L | "Invalid table name %2 specified for option 'identity_insert'. %1" | The table associated with the table name specified for the 'identity_insert' option could not be found. Click here for a list of possible parameters and odbc states. |
| 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. |