Troubleshooting Sybase Error Code from Error 20880 to 20895


Sybase Error Code 20880
Sybase SQL Code 1000220L
Left Rows: %1, Right Rows: %2, Ratio: %3 to %4\n
Sybase Error Code 20881
Sybase SQL Code 1000221L
Right Rows Skipped: %1 (former left outers).\n
Sybase Error Code 20882
Sybase SQL Code –1000222L
Sybase Error Code 20883
Column name ‘%2’ is invalid. The column name must follow the format [OWNER.]TABLE.COLUMN. %1

Sybase Error Code 20884
Sybase SQL Code 1000224L
Join record rejected: ‘%1’, duplicate rows in 1st indexset. \nRow# %2 & %3X, row %4 rejected.
Sybase Error Code 20885
Sybase SQL Code -1000225L
Cannot open table %2. The table has already been opened by a cursor declared FOR UPDATE in transaction %3. %1
Sybase Error Code 20886
Sybase SQL Code 1000226L
\n Inner Rows: %1, Left Outer Rows: %2, Right Outer Rows: %3
Sybase Error Code 20887
Sybase SQL Code 1000227L
Join Rows: %1, Left m2m Rows: %2, Right m2m Rows: %3\n
Sybase Error Code 20888
Sybase SQL Code –1000228L

Sybase Error Code 20889
Sybase SQL Code 1000229L
%1 records were inserted and %2 records were rejected for %3 tables \nfor join index ‘%4’.\n
Sybase Error Code 20890
Sybase SQL Code 1000230L
\nInsert for ‘%1’,\n completed in %2 seconds.
Sybase Error Code 20891
Sybase SQL Code –1000231L
You do not have permission to create join index %2%3%4. %1
Sybase Error Code 20893
Sybase SQL Code –1000233L
Cannot SYNCHRONIZE join index %2. %1
Sybase Error Code 20894
Sybase SQL Code 1000234L
\nInsertt into table ‘%1’, %2 rows rejected (in all).
Sybase Error Code 20895
Sybase SQL Code 1000235L
%3 Pass %1 completed in %2 seconds.

Above are list of Sybase Error Code Messages from Error Code 20880 to 20895 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 *