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 |
|---|---|---|---|---|---|
| QNA29 | Error | 21059 | -1008029L | "Cannot create foreign key to an unenforced primary key or unenforced unique constraint." | Existing unenforced primary keys or unique constraints cannot be used to create an referential integrity relationship to a foreign table. Click here for a list of possible parameters and odbc states. |
| QNA30 | Error | 21064 | -1008030L | "Only IQ index types can be created on IQ tables within a Parallel IQ block." | Parallel IQ Begin/End blocks allow users to create multiple indexes simultaneously. At this time, only Create Index statements for HG, HNG, LF, LD, DATE, TIME, WD, and CMP index types on IQ tables are allowed within Parallel IQ Begin and End statements. Click here for a list of possible parameters and odbc states. |
| QNA31 | Error | 21065 | -1008031L | "Cannot do Create Index commands on global or local temporary tables or catalog server tables in a Parallel IQ block." | Cannot do Create Index commands on global or local temporary tables in a Parallel IQ block. Click here for a list of possible parameters and odbc states. |
| QNA32 | Error | 20823 | -1000163L | "%1 not supported." | The named operation is not supported. Click here for a list of possible parameters and odbc states. |
| QNA33 | Error | 20824 | -1000164L | "Only %1 supported." | Only UPDATE RESTRICT and DELETE RESTRICT supported Click here for a list of possible parameters and odbc states. |
| QNA34 | Error | 20825 | -1000165L | "Only a single foreign key constraint can be created on the same foreign key column(s) and same candidate key column(s)." | For a given set of foreign key columns and candidate key columns, Click here for a list of possible parameters and odbc states. |
| QNA35 | Error | 20828 | -1000168L | "Cannot create %1 HG index because one already exists on the given columns." | Only a single HG index of a given type can be created on the same column set. For example, you cannot have two unique HG indexes on the same column set, but you are allowed to have a unique HG and a non-unique HG index on the same set of columns. Click here for a list of possible parameters and odbc states. |
| QNA36 | Error | 20829 | -1000169L | "Cannot create unique HG index because primary key or unique constraint already exists on the given columns." | When you create a primary key or unique constraint, IQ automatically creates a unique HG index as the mechanism for enforcing the 'uniqueness' attribute of a primary key or unique constraint. Consequently, a user cannot create another unique HG on the same columns on which the primary key or unique constraint is defined. Click here for a list of possible parameters and odbc states. |
| QNA37 | Error | 20830 | -1000170L | "Cannot create a duplicate '%1' index '%2'." | Cannot create duplicate indexes of the same type on a set of columns. Click here for a list of possible parameters and odbc states. |
| QNA38 | Error | 20833 | -1000173L | "Index '%1' cannot be created. Multicolumn indexes must be created using distinct columns." | Multicolumn indexes must be created using distinct columns. That is, you cannot use the same column more than once when creating a multicolumn index. Click here for a list of possible parameters and odbc states. |
| QNA39 | Error | 20845 | -1000185L | "Cannot drop table %1 because foreign keys still reference it." | The named table cannot be dropped until all foreign keys referencing it have first been dropped. Click here for a list of possible parameters and odbc states. |
| QNA40 | Error | 20846 | -1000186L | "Cannot create foreign key constraint on a candidate key that is also a foreign key." | A candidate key cannot also be a foreign key. Here's an example illustrating what is meant by this exception. (1) A [pk] <----- B [fk] [pk] <-- ADD THIS ONE -- C[fk] (2) A [pk] <-- ADD THIS ONE -- B[fk] [pk] <------- C[fk] In case (1), adding foreign key C[fk] is disallowed. In case (2), adding foreign key B[fk] is disallowed. Click here for a list of possible parameters and odbc states. |
| QNA41 | Error | 20026 | -1008032L | "Foreign keys disallowed on Identity/Autoincrement Columns when set option identity_enforce_uniqueness is on" | An Identity/Autoincrement Column cannot be a foreign key when the set option identity_enforce_uniqueness is on. Either turn the option off, or chose a different column for the foreign key. Click here for a list of possible parameters and odbc states. |
| QNA42 | Error | 20027 | -1008033L | "Identity/Autoincrement Column %1 has Invalid datatype: scale must be 0." | Identity/Autoincrement Columns defined as datatype numeric must have scale 0 Click here for a list of possible parameters and odbc states. |
| QNA43 | Error | 20028 | -1008034L | "Cannot add an Identity/Autoincrement Column to table %1, it participates in a join index." | Adding an Identity/Autoincrement Column to a table that participates in a join index is not allowed, to perform this operation, the join index must be dropped Click here for a list of possible parameters and odbc states. |
| QNA44 | Error | 20029 | -1008035L | "Invalid datatype for Identity/Autoincrement Column %1." | The datatype used is not supported by Identity/Autoincrement column. Valid datatypes are bigint, unsigned bigint, integer, unsigned integer, smallint, tinyint, numeric scale 0 and decimal scale 0 Click here for a list of possible parameters and odbc states. |
| QNA45 | Error | 20642 | -1008036L | "Table %1 already has an Identity/Autoincrement Column. " | An Identity/Autoincrement Column cannot be added to this table because it already has one. Click here for a list of possible parameters and odbc states. |
| QNA46 | Error | 20643 | -1008037L | "Cannot drop %1 %2: set option 'identity_insert' must be off. " | option 'identity insert' must not be set to any table name to drop an Identity Column. To turn it off use 'set identity_insert '' ' Click here for a list of possible parameters and odbc states. |
| QNA47 | Error | 21123 | -1008038L | "create schema command not allowed on an active multiplex server. " | the create schema command is not allowed on an active multiplex server Click here for a list of possible parameters and odbc states. |
| QNA48 | Error | 22005 | -1008039L | "Permission denied: The current multiplex server is not a writer server" | The global command is not permitted on current multiplex node Click here for a list of possible parameters and odbc states. |