Messages QCA23 through QCA43

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
QCA23 Error 20593 -1013023L "Cannot create a unique '%2' index. %1" Fast Projection, Low Disk, and High Non Group index types cannot be created as unique.

Click here for a list of possible parameters and odbc states.

QCA24 Error 20594 -1013024L "ALTER TABLE MODIFY <column> <datatype> is not supported. %1" Cannot modify the datatype of a column.

Click here for a list of possible parameters and odbc states.

QCA25 Error 20595 -1013025L "ALTER TABLE MODIFY <default-value> is not supported. %1" Cannot modify the default value of a column as defaults are not supported.

Click here for a list of possible parameters and odbc states.

QCA27 Error 20597 -1013027L "Number of bytes (%2) for a column from an input file has exceeded the maximum allowed (%3). %1" The number of bytes you are trying to load into a column from an input file has exceeded the maximum number of bytes allowed.

Click here for a list of possible parameters and odbc states.

QCA28 Error 20598 -1013028L "An invalid size (too large) was specified for a LOAD option. %1" A size too large was specified for a LOAD option. Check the options specified for the LOAD statement.

Click here for a list of possible parameters and odbc states.

QCA29 Error 20599 -1013029L "The INSERT...LOCATION statement must have a SELECT statement. %1" The INSERT...LOCATION statement must use a SELECT statement to provide the data for insertion. No other SQL statement type is supported here.

Click here for a list of possible parameters and odbc states.

QCA30 Error 20600 -1013030L "Join index '%2' cannot be found. %1" The named join index cannot be found.

Click here for a list of possible parameters and odbc states.

QCA31 Error 20601 -1013031L "An error occurred while calling a method on db_sql_*_identifier. Object does not have an ITable handle. %1" This error should not occur during normal operation. It is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA32 Error 20602 -1013032L "No database is currently in use. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA33 Error 20603 -1013033L "An error occurred while calling a method on db_sql_*_identifier. Object does not have an IJoinIndex handle. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA34 Error 20604 -1013034L "Cannot create an index with no columns. %1" You cannot create an index with no columns.

Click here for a list of possible parameters and odbc states.

QCA35 Error 20605 -1013035L "The number of insert VALUES does not match the column list. %1" The number of columns in the INSERT does not match the number of of VALUES provided.

Click here for a list of possible parameters and odbc states.

QCA36 Error 20606 -1013036L "The keyword 'FILLER' is not valid in this context. %1" You cannot use the 'FILLER' keyword here. No column can be of type 'FILLER' for a VALUES insert.

Click here for a list of possible parameters and odbc states.

QCA37 Error 20607 -1013037L "The datatype of column '%2' is not valid. %1" The named column has an invalid datatype. If subsequent examination of the column definition reveals a datatype that is valid, then this error should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA38 Error 20608 -1013038L "The number of columns given does not match. %1" The number of columns to be inserted does not match the number of columns in the insert. If this error persists, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA39 Error 20609 -1013039L "An internal error occurred while constructing a db_sql_*_identifier. The IColumn handle does not belong to the ITable. %1" This error should not occur during normal operation. It is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA40 Error 20610 -1013040L "Column '%2' in the INSERT list has no matching column in the SELECT list. %1" The named column in the INSERT list does not have a matching column in the SELECT list.

Click here for a list of possible parameters and odbc states.

QCA41 Error 20611 -1013041L "Column '%2' in the SELECT list has no matching column in the INSERT list. %1" The named column in the SELECT list does not have a matching column in the INSERT list.

Click here for a list of possible parameters and odbc states.

QCA42 Error 20612 -1013042L "An internal error occurred while constructing a db_sql_*_identifier. The IIndex handle does not belong to the ITable. %1" This error should not occur during normal operation. It is an internal error. If this error occurs it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

QCA43 Error 20613 -1013043L "Unable to convert column '%2' to the requested datatype (%3) from datatype (%4). %1" This column cannot be converted to the requested datatype.

Click here for a list of possible parameters and odbc states.


Created June 15, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com