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 |
|---|---|---|---|---|---|
| -1010006L | Error | 20020 | QXA06 | "Maximum blocks for dbspace '%2' is %3 blocks. %4 blocks were specified. (Database blocksize is %5.) %1" | Given a database's BLOCK SIZE and the number of blocks specified by the user for the dbspace, the dbspace size (in bytes) would exceed the OS's limit of bytes per file. Click here for a list of possible parameters and odbc states. |
| -1010007L | Error | 20980 | QXA07 | "The number of blocks (%3) for dbspace '%2' must be less than or equal to the number of blocks in the raw partition (%4). %1" | When creating a dbspace on a raw partition, if the user specifies the dbspace's size, then it must exactly match the size of the raw partition. Click here for a list of possible parameters and odbc states. |
| -1010008L | Error | 20981 | QXA08 | "For an IQ PAGE SIZE of %2, the dbspace '%3' must have at least %4 MB. %1" | The named dbspace must have the stated minimum size in megabytes. Click here for a list of possible parameters and odbc states. |
| -1010009L | Error | 21005 | QXA09 | "Improper use of cursor - programmer error %1" | The programmer has misused the internal cursor class(es) Click here for a list of possible parameters and odbc states. |
| -1010010L | Error | 21006 | QXA10 | "An invalid attribute flag was passed to the cursor" | A state violation was detected in the cursor Click here for a list of possible parameters and odbc states. |
| -1010011L | Error | 21007 | QXA11 | "Not enough server threads available for this query." | No thread could be allocated to allow this query to be executed Click here for a list of possible parameters and odbc states. |
| -1010012L | Error | 21008 | QXA12 | "The cursor is in an invalid state %1" | A state violation was detected in the cursor Click here for a list of possible parameters and odbc states. |
| 1010013L | Warning | 21024 | 00A13 | "IQ cannot support the %1 connections requested by the server.\nRestart the server with -gm %2 on the command line." | Inform the DBA about the number of connection Click here for a list of possible parameters and odbc states. |
| -1010013L | Error | 21025 | QXA13 | "Raw partition %2 is already in use. %1" | User attempted to create dbspace on a raw partition which is currently in use by the database. Click here for a list of possible parameters and odbc states. |
| 1010014L | Warning | 21058 | QXA14 | "Default cache size is used for command %1." | warning is issued for the command that uses the default cache size Click here for a list of possible parameters and odbc states. |
| -1010015L | Error | 21075 | QXA15 | "The MAIN store is out of space. Space must be added to the MAIN store first. %1" | The MAIN store is out of space. Space must be added to the MAIN store before space can be added to any other store. Click here for a list of possible parameters and odbc states. |
| -1010016L | Error | 21076 | QXA16 | "The TEMPORARY store is out of space. Space must be added to the TEMPORARY store first. %1" | The TEMPORARY store is out of space. Space must be added to the TEMPORARY store before space can be added to any other store. Click here for a list of possible parameters and odbc states. |
| -1010017L | Error | 21111 | QXA17 | "You cannot create tables on a secondary server without a readwrite local IQ Store. %1" | MPX secondary servers can only create IQ objects in a local store. Click here for a list of possible parameters and odbc states. |
| -1010018L | Error | 21112 | QXA18 | "Shared and local tables cannot participate in a JOIN INDEX. %1" | Cannot create a join index between a main and a local table. Click here for a list of possible parameters and odbc states. |
| -1010019L | Error | 21113 | QXA19 | "A query server may not modify objects in the main IQ Store. %1" | A query server may not modify objects in the main store. Click here for a list of possible parameters and odbc states. |
| -1010020L | Error | 21114 | QXA20 | "Backup not allowed on secondary servers. %1" | The backup command is not allowed to be executed on a secondary server. Execute the command on the coordinator. Click here for a list of possible parameters and odbc states. |
| -1010021L | Error | 21115 | QXA21 | "Foreign key constraint on a local table cannot reference a shared table. %1" | Cannot combine main and local tables in a foreign key relationship. Click here for a list of possible parameters and odbc states. |
| -1010022L | Error | 21117 | QXA22 | "Cannot modify main store from a multiplex query server. %1" | The general error when a query server tries to modify the shared main store. There are other more detailed messages for specific cases. Click here for a list of possible parameters and odbc states. |
| -1010023L | Error | 21121 | QXA23 | "Cursor is not updatable: %2. %1" | Cursor is not updatable: there are join/group by/distinct/set, union, olap function, or no updatable columns. Click here for a list of possible parameters and odbc states. |
| -1010024L | Error | 21122 | QXA24 | "Column '%2' is not updatable. %1" | Column is not updatable if it is long binary/varchar, rowid, (var)binary when ASE_Binary_Display is ON, referenced by other expressions in the select list, identity column, or not in FOR UPDATE of list. Click here for a list of possible parameters and odbc states. |