Troubleshooting Sybase Error Code from Error 20999 to 21013

SQLServerF1

Sybase Error Code 20999
Sybase SQL Code –1000230L
Columns that allow nulls must use the WITH NULL BYTE option. %1
Sybase Error Code 21000
Sybase SQL Code –1000234L
The record size of the unloaded data: %2, does not match the record size of the load: %3. %1
Sybase Error Code 21001
Sybase SQL Code –1000235L
The total number of columns of unloaded data: %2, does not match the total number of columns in the load: %3. %1
Sybase Error Code 21002
Sybase SQL Code –1000236L
The total number of null columns in the unloaded data, %2, does not match the total number of null columns in the LOAD command, %3. %1

Sybase Error Code 21003
Sybase SQL Code –1000237L
The total number of variable width columns in the unloaded data, %2, does not match the total number of variable width columns in the LOAD command, %3. %1
Sybase Error Code 21004
Sybase SQL Code –1013098L
The foreign key %2 participates in join %3 and can not be ALTERed. %1
Sybase Error Code 21005
Sybase SQL Code –1010009L
Improper use of cursor – programmer error %1
Sybase Error Code 21006
Sybase SQL Code –1010010L
An invalid attribute flag was passed to the cursor
Sybase Error Code 21007
Sybase SQL Code –1010011L
Not enough server threads available for this query.

Sybase Error Code 21008
Sybase SQL Code –1010012L
The cursor is in an invalid state %1
Sybase Error Code 21009
Sybase SQL Code –1000238L
The platform type of the unloaded data, %2, does not match the platform type on the load, %3. %1
Sybase Error Code 21010
Sybase SQL Code –1000239L
UNLOAD version number: %2, does not match the LOAD version number: %3. %1
Sybase Error Code 21011
Sybase SQL Code –1000240L
The total number of blocks of unloaded data: %2, does not match the total number of blocks loaded: %3. %1
Sybase Error Code 21012
Sybase SQL Code –1000242L
Total number of rows of unloaded data: %2, does not match the total number of rows in the load: %3. %1
Sybase Error Code 21013
Sybase SQL Code –1000243L
The unload format number: %2, does not match the load format number: %3. %1

Above are list of Sybase Error Code Messages from Error Code 20999 to 21013 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.

Thanks,
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 *