Troubleshooting Sybase Error Code from Error 20847 to 20861


Sybase Error Code 20847
Sybase SQL Code –1000187L
Unable to implicitly convert column ‘%2’ to datatype (%3) from datatype (%4). %1
Sybase Error Code 20848
Sybase SQL Code –1000188L
Only ASCII and BINARY are supported LOAD formats. %1
Sybase Error Code 20849
Sybase SQL Code –1000189L
DDL statements cannot proceed while the %2 is in an out of space condition. %1
Sybase Error Code 20850
Sybase SQL Code –1000190L
The index ‘%2’ cannot be opened in the current transaction (%3). %1

Sybase Error Code 20851
Sybase SQL Code –1000191L
Proxy, remote, or non-IQ tables are not allowed in joins. Tablename is ‘%2’. %1
Sybase Error Code 20852
Sybase SQL Code –1000192L
The cursor for table ‘%2’ has no data to fetch. %1
Sybase Error Code 20853
Sybase SQL Code –1000193L
The table ‘%2’ is either not part of the join virtual table or has had its data loaded through linked indices. %1
Sybase Error Code 20854
Sybase SQL Code –1000194L
You must supply either a cursor count (%2) and a cursor array, or neither. %1
Sybase Error Code 20855
Sybase SQL Code –1000195L
Load specification ‘%2’ only valid for column(s) having datatype ‘%3’. %1

Sybase Error Code 20856
Sybase SQL Code –1000196L
You must supply a join index name. %1
Sybase Error Code 20857
Sybase SQL Code –1000197L
Table ‘%2’ has no columns in the cursor that don’t already have data, \nor the join field(s) are not part of the cursor. %1
Sybase Error Code 20858
Sybase SQL Code –1000198L
Cannot create join index with table(s) having column(s) of datatype %2. %1
Sybase Error Code 20859
Sybase SQL Code 1000199L
Table ‘%1’ has no data.
Sybase Error Code 20860
Sybase SQL Code –1000200L
Table ‘%2’ has no data with which to join the other tables. %1
Sybase Error Code 20861
Sybase SQL Code –1000201L
JOIN cannot be created or updated because the thread’s stack space has been exceeded. %1

Above are list of Sybase Error Code Messages from Error Code 20847 to 20861 received while performing certain operation against Sybase Database or related products.

What are Sybase Error Codes?

Sybase error codes are a set of error codes for use by all Sybase products, including Adaptive Server Enterprise. For every Sybase error code returned by Sybase IQ, there is a pair of matching Sybase IQ error codes (SQLCODE and SQLSTATE). In many cases Sybase IQ error codes offer a finer level of granularity than their Sybase error code counterparts, thus some Sybase error codes in the following table are non-unique.

Many of the errors contain the characters %1, %2 and so on. These are replaced by the parameters to the error message.

Hope this was helpful.

SQLServerF1 Team
Information about Sybase Error Code Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *