Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Error 1013041 | "Column '%2' in the SELECT list has no matching column in the INSERT list. %1" |
|---|---|
Constant | EMSG_SQL_INSERTNOMATCHCLIST |
SAP Sybase Error Number | 20611 |
SQL State | QCA41 |
SQL Code | -1013041L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column |
Probable Cause | The named column in the SELECT list does not have a matching column in the INSERT list. |
| Error 1013042 | "An internal error occurred while constructing a db_sql_*_identifier. The IIndex handle does not belong to the ITable. %1" |
|---|---|
Constant | EMSG_SQL_INDEXMISMATCH |
SAP Sybase Error Number | 20612 |
SQL State | QCA42 |
SQL Code | -1013042L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | This error should not occur during normal operation. It is an internal error. If this error occurs it should be reported to Sybase. |
| Error 1013043 | "Unable to convert column '%2' to the requested datatype (%3) from datatype (%4). %1" |
|---|---|
Constant | EMSG_SQL_INVALIDCONVERSION |
SAP Sybase Error Number | 20613 |
SQL State | QCA43 |
SQL Code | -1013043L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column |
Parameter 3 | requested datatype |
Parameter 4 | current datatype |
Probable Cause | This column cannot be converted to the requested datatype. |
| Error 1013044 | "An internal error occurred. An invalid table type was encountered. %1" |
|---|---|
Constant | EMSG_SQL_INVALID_TBL_TYPE |
SAP Sybase Error Number | 20614 |
SQL State | QCA44 |
SQL Code | -1013044L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | This is an internal programming error. The table type was not correctly set to BASE, VIEW, JVT, TMP, LOCAL TMP for its context. If this error occurs it should be reported to Sybase. |
| Error 1013045 | "An invalid file name ('%2') was specified for a LOAD TABLE. The file name has zero length. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDFILENAME |
SAP Sybase Error Number | 20615 |
SQL State | QCA45 |
SQL Code | -1013045L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | file name |
Probable Cause | A file name of zero length was specified for LOAD TABLE. |
| Error 1013046 | "An internal error occurred. An invalid index type was encountered. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDINDEXTYPE |
SAP Sybase Error Number | 20616 |
SQL State | QCA46 |
SQL Code | -1013046L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | This error should not occur during normal operation. It is an internal error and should be reported to Sybase. |
| Error 1013047 | "Cannot alter index '%2'. Only indexes in base tables or global temporary tables can be altered. %1" |
|---|---|
Constant | EMSG_SQL_CANNOT_ALTER_INDEX |
SAP Sybase Error Number | 20617 |
SQL State | QCA47 |
SQL Code | -1013047L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Parameter 2 | Indexname. |
Probable Cause | Only indexes in base tables and global temporary tables listed in SYS.SYSINDEX can be altered. |
| Warning 1013048 | "Warning: Partial input record (%1 bytes) skipped at EOF (O/S %2). %3 rows read." |
|---|---|
Constant | EMSG_SQL_INSERTPARTIALRECORD |
SAP Sybase Error Number | 20618 |
SQL State | 01A48 |
SQL Code | 1013048L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | number of bytes at end of file that were skipped |
Parameter 2 | operating system error |
Parameter 3 | number of rows read from the input file |
Probable Cause | An incomplete input record was found at the end of the flat file. If the operating system error returned is not zero, you may need to take action as dictated by the error and try the LOAD again. |
| Warning 1013049 | "******* Possible Tape/File Error *******\n\n Bytes Read: %1, O/S errno: %2\n %3 rows read. Input suspended." |
|---|---|
Constant | EMSG_SQL_INSERTTAPEERROR |
SAP Sybase Error Number | 20619 |
SQL State | 01A49 |
SQL Code | 1013049L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | number of bytes read |
Parameter 2 | operating system error number |
Parameter 3 | number of rows read |
Probable Cause | Take action as dictated by the operating system error and retry the operation. |
| Error 1013050 | "The Temp_Extract_Name1 option is set. The current operation will be rolled back. %1" |
|---|---|
Constant | EMSG_SQL_OP_PROHIBITED |
SAP Sybase Error Number | 20620 |
SQL State | QCA50 |
SQL Code | -1013050L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | Certain operations will not be allowed whenever the Temp_Extract_Name1 option is set. They are: INSERT...VALUES, LOAD, DELETE, and INSERT...LOCATION if the table being inserted, SYNCHRONIZE join index. (Which also may be executed as part of CREATE JOIN INDEX.) loaded or deleted from is the top table in a join. INSERT...SELECT. For example, 'insert t1 select * from t2'. |
| Error 1013052 | "The BLOCK FACTOR for LOAD cannot be zero. %1" |
|---|---|
Constant | EMSG_SQL_BLOCKFACTOR_IS_ZERO |
SAP Sybase Error Number | 20622 |
SQL State | QCA52 |
SQL Code | -1013052L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | The BLOCK FACTOR for LOAD cannot be zero. |
| Error 1013054 | "Delimiter '%2' must be 1 to %3 characters in length. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDDELIMITERSIZE |
SAP Sybase Error Number | 20624 |
SQL State | QCA54 |
SQL Code | -1013054L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | delimiter |
Parameter 3 | maximum allowable length of column delimiter or row terminator |
Probable Cause | The row or column delimiter in a LOAD statement must be 1-4 characters. |
| Error 1013055 | "ON_ERROR = 'CONTINUE' is valid only for a full-width INSERT. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDCONTINUE |
SAP Sybase Error Number | 20625 |
SQL State | QCA55 |
SQL Code | -1013055L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | ON_ERROR = 'CONTINUE' is valid only for a full width insert. |
| Error 1013056 | "FILLER width must be greater than zero. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDFILLERWIDTH |
SAP Sybase Error Number | 20626 |
SQL State | QCA56 |
SQL Code | -1013056L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | FILLER width must be greater than zero. |
| Error 1013057 | "ASCII input column width must be greater than zero. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDASCIIWIDTH |
SAP Sybase Error Number | 20627 |
SQL State | QCA57 |
SQL Code | -1013057L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | ASCII input column width must be greater than zero. |
| Error 1013058 | "The row delimiter must be distinct from all column delimiters. %1" |
|---|---|
Constant | EMSG_SQL_IDENTICALDELIMITERANDROWTERMINATOR |
SAP Sybase Error Number | 20628 |
SQL State | QCA58 |
SQL Code | -1013058L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | The row delimiter cannot be the same as any column delimiter. |
| Error 1013059 | "The BLOCK SIZE option is not valid for a fixed-width input insert. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDBLOCKSIZEOPTION |
SAP Sybase Error Number | 20629 |
SQL State | QCA59 |
SQL Code | -1013059L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | You cannot specify BLOCK SIZE for a fixed-width input insert. |
| Error 1013060 | "The BLOCK FACTOR option is not valid for a variable width input insert. %1" |
|---|---|
Constant | EMSG_SQL_INVALIDBLOCKFACTOROPTION |
SAP Sybase Error Number | 20630 |
SQL State | QCA60 |
SQL Code | -1013060L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | You cannot specify BLOCK FACTOR for a variable width input insert. |
| Error 1013061 | "Missing row delimiter detected during a row delimited insert. %1" |
|---|---|
Constant | EMSG_SQL_MISSINGROWTERMINATOR |
SAP Sybase Error Number | 20631 |
SQL State | QCA61 |
SQL Code | -1013061L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | The input data is missing a row delimiter. |
| Error 1013062 | "Expected '%2' delimited column type on input, but encountered a row delimiter instead. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file. %1" |
|---|---|
Constant | EMSG_SQL_EXPECTEDFIELDTYPENOTSEEN |
SAP Sybase Error Number | 20632 |
SQL State | QCA62 |
SQL Code | -1013062L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | expected datatype of column |
Probable Cause | A row delimiter, rather than a column, was encountered during a LOAD. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file. |