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 |
|---|---|---|---|---|---|
| QDA98 | Error | 20758 | -1000098L | "Creating a join index on a column of type 'varchar' or 'varbinary' with size > 255 is not supported. %1" | IQ does not support creating a join index on columns that are of datatype 'varchar' whose size is greater than 255. Click here for a list of possible parameters and odbc states. |
| QDA99 | Error | 20759 | -1000099L | "The PAGE SIZE divided by the BLOCK SIZE must be equal to 2, 4, 8, or 16. DATABASE: %2 PAGE SIZE: %3 BLOCK SIZE: %4 %1" | (PAGE SIZE)/(BLOCK SIZE) must be one of 2, 4, 8, 16. Adjust the PAGE SIZE or the BLOCK SIZE in the CREATE DATABASE statement. Click here for a list of possible parameters and odbc states. |
| QDB00 | Error | 20760 | -1000100L | "Cannot INSERT, LOAD, or UPDATE a join virtual table. %1" | The user is not allowed to INSERT to or LOAD a join virtual table. Instead you must INSERT to or LOAD the tables which participate in the join and and execute the SYNCHRONIZE command. Click here for a list of possible parameters and odbc states. |
| QDB01 | Error | 20761 | -1000101L | "%2 not supported by Sybase IQ. %1" | The statement in question is not supported by Sybase IQ. Click here for a list of possible parameters and odbc states. |
| QDB02 | Error | 20762 | -1000102L | "Cannot update table %2 because it is defined in one or more join indexes. %1" | The user cannot update a table that is defined on a join index. Click here for a list of possible parameters and odbc states. |
| QDB03 | Error | 20763 | -1000103L | "Cannot find an index for field '%2'. Every field must have at least one index. Current IndexCount = %3. %1" | This error should not occur during normal operation. Every field in ASIQ will have at least one index (the automatically generated FP index). This error occurs, the operation should be retried. If the error persists, it should be reported to Sybase. Extra information may have been output to the iqmsg file. Click here for a list of possible parameters and odbc states. |
| QDB04 | Error | 21077 | -1000264L | "Ambiguous index name '%2'. Please specify owner. %1" | The specified index name is shared by more than one owner. The owner can be specified as OWNER.TABLE.INDEX Click here for a list of possible parameters and odbc states. |
| QDB05 | Error | 21078 | -1000265L | "Index '%2' not found. %1" | The specified index could not be opened. Either the index does not exists or the name format is incorrect The index name must follow the format [OWNER.]TABLE.INDEX Click here for a list of possible parameters and odbc states. |
| QDB06 | Error | 20766 | -1000106L | "Local temporary table, %2, must be committed in order to create an index. %1" | To be able to create an index for a local temporary table, the table must be in a committed state. If this message occurs, the user has tried to execute a CREATE INDEX on a local temporary table that has had data inserted, deleted, or updated that has not yet been committed. Click here for a list of possible parameters and odbc states. |
| QDB07 | Error | 21080 | -1000267L | "Cannot convert '%2' to an integer percent. %1" | The percent must be an integer value Click here for a list of possible parameters and odbc states. |
| QDB08 | Error | 21081 | -1000268L | "The target '%2' overlaps an earlier target. %1" | The user cannot specify an index or table multiple times. This also applies to an index that was already included by specifying its table. Click here for a list of possible parameters and odbc states. |
| QDB09 | Error | 21079 | -1000266L | "Table '%2' not found. %1" | The specified table could not be opened. Either the table does not exists or the name format is incorrect The table name must follow the format [OWNER.]TABLE Click here for a list of possible parameters and odbc states. |
| QDB10 | Error | 20770 | -1000110L | "The wrong SIndex has been opened for a fast projection index. %1" | This is an internal error and should not occur. Diagnostic information has been output to the iqmsg file. If the error occurs, it should be reported to Sybase. The operation that caused the error may be tried again. Click here for a list of possible parameters and odbc states. |
| QDB11 | Error | 20771 | -1000111L | "The wrong FP Index has been opened for a field. %1" | This is an internal error and should not occur. Diagnostic information has been output to the iqmsg file. If the error occurs, it should be reported to Sybase. The operation that caused the error may be tried again. Click here for a list of possible parameters and odbc states. |
| QDB12 | Error | 20772 | -1000112L | "The EBM on the field's columnDescriptor does not match the column EBM on the FPIndex. %1" | This is an internal error and should not occur. Diagnostic information has been output to the iqmsg file. If the error occurs, it should be reported to Sybase. The operation that caused the error may be tried again. Click here for a list of possible parameters and odbc states. |
| QDB13 | Error | 20773 | -1000113L | "Field %2 does not have an FP index. %1" | This error should not occur during normal operation. Every field has an FP index which is created automatically when the field is created. If the error occurs, diagnostic information will be output to the iqmsg file and the operation that caused it may be tried again. If the problem persists, the server should be shutdown and restarted. An occurrence of this error should be reported to Sybase. Click here for a list of possible parameters and odbc states. |
| QDB14 | Error | 20774 | -1000114L | "CMP index can only be created on two distinct columns having identical datatypes. %1" | A CMP index is an index that can be only created on two columns. You cannot create a single column CMP index; nor can you create a CMP index on three or more columns. Furthermore, when specifying two columns, the two columns must have identical datatypes. Click here for a list of possible parameters and odbc states. |
| QDB15 | Error | 20775 | -1000115L | "You cannot delete from join index %2 in the 'top' table %3. %1" | This is an internal error. You cannot delete from the top table in a join. If this error occurs, it should be reported to Sybase Click here for a list of possible parameters and odbc states. |
| QDB16 | Error | 20776 | -1000116L | "A temporary table cannot participate in a JOIN INDEX. '%2' is a temporary table. %1" | You cannot create a join index using a temporary table. Click here for a list of possible parameters and odbc states. |
| QDB18 | Error | 20778 | -1000118L | "Join index %2 was not found in the catalog. %1" | This is an internal error. If this error occurs, it should reported to Sybase. Click here for a list of possible parameters and odbc states. |