Messages on this page are sorted by Sybase error code. Locate the appropriate code in the table below, and click the link for a full description of the message.
| Number | Msg Type | SQL State | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| 21062 | Error | QTA20 | -1005020L | "Only single-table updates are supported by Sybase IQ" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 21063 | Error | QTA21 | -1005021L | "Sybase IQ does not allow subqueries in update set-items" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 21064 | Error | QNA30 | -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. |
| 21065 | Error | QNA31 | -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. |
| 21066 | Error | QTA22 | -1005022L | "Aggregate not valid in update set-item expression." | No additional information available. Click here for a list of possible parameters and odbc states. |
| 21067 | Warning | QSB39 | 1009142L | " %1 SortMerge0: %2 records, PhaseI=%3 Secs, %4 runs total, %5 pgs=%6 M, runlen=%7, %8 est. phases" | This information is provided after the Phase I radix sorting is complete and the Phase II merge-sorting is about to begin. Each run consists of a sequence of pages that have been radix sorted in Phase I. These runs are merged together in Phase II to finish the sort. Click here for a list of possible parameters and odbc states. |
| 21068 | Warning | QSB40 | 1009143L | " %1 SortMergePass: Merged %2 runs, %3 Secs, %4 runs remaining, %5 reads = %6 M, runlen=%7, phase %8, %9 M on disk" | This information is provided after each merge pass. One merge pass merges a certain number of runs, using one pinned buffer page per run plus one pinned buffer for the output run. Note that there can be several passes in a merge phase. One merge phase reads all the sort data and produces a new set of runs that provide input to the next phase. Click here for a list of possible parameters and odbc states. |
| 21069 | Warning | QSB41 | 1009144L | " %1 SortMergeDone: Ave mem %2 M, %3 Secs, %4 passes, %5 reads, %6 M data= %7 pgs, %8 phases, %9 M on disk" | This information is provided at the end of Phase II to summarize the resource usage of the whole merge sort. The last pass of the sort is separately reported on by an EMSG_SORT_INFOMERGED1 message. Click here for a list of possible parameters and odbc states. |
| 21070 | Error | QFA2E | -1009145L | "Data exception - data type conversion is not possible. %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 21071 | Error | QSB42 | -1009146L | "Cannot perform requested command as there is a DBCC command in progress. %1" | A CHECKPOINT command was issued when there was already a DBCC command in progress. Click here for a list of possible parameters and odbc states. |
| 21072 | Error | QBC64 | -1006264L | "Invalid Blocksize %2 less than the Device Sectorsize %3 %4 %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 21073 | Error | QTA23 | -1005023L | "Unmatched number of select list items in union" | Cube message here Click here for a list of possible parameters and odbc states. |
| 21074 | Error | QTA24 | -1005024L | "Estimate number: %2 exceed the MAX_CUBE_RESULT of GROUP BY CUBE or ROLLUP %1" | location of the exception the estimated total result of hash base cube or rollup Click here for a list of possible parameters and odbc states. |
| 21075 | Error | QXA15 | -1010015L | "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. |
| 21076 | Error | QXA16 | -1010016L | "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. |
| 21077 | Error | QDB04 | -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. |
| 21078 | Error | QDB05 | -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. |
| 21079 | Error | QDB09 | -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. |
| 21080 | Error | QDB07 | -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. |
| 21081 | Error | QDB08 | -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. |