Troubleshooting Sybase Error Code from Error 20755 to 20770

SQLServerF1

Sybase Error Code 20755
Sybase SQL Code 1000095L
The join index %1 could not be used in the query because it needs synchronization.
Sybase Error Code 20756
Sybase SQL Code 1000096L
Delimiter %1 %2 nulls, %3%4%5 %6
Sybase Error Code 20757
Sybase SQL Code –1000097L
Parse Error in Command String at ‘%2’. %1
Sybase Error Code 20758
Sybase SQL Code –1000098L
Creating a join index on a column of type ‘varchar’ or ‘varbinary’ with size > 255 is not supported. %1

Sybase Error Code 20759
Sybase SQL Code –1000099L
The PAGE SIZE divided by the BLOCK SIZE must be equal to 2, 4, 8, or 16. DATABASE: %2 PAGE SIZE: %3 BLOCK SIZE: %4 %1
Sybase Error Code 20760
Sybase SQL Code –1000100L
Cannot INSERT, LOAD, or UPDATE a join virtual table. %1
Sybase Error Code 20761
Sybase SQL Code –1000101L
%2 not supported by Sybase IQ. %1
Sybase Error Code 20762
Sybase SQL Code –1000102L
Cannot update table %2 because it is defined in one or more join indexes. %1

Sybase Error Code 20763
Sybase SQL Code –1000103L
Cannot find an index for field ‘%2’. Every field must have at least one index. Current IndexCount = %3. %1
Sybase Error Code 20764
Sybase SQL Code 1000104L
in join virtual table ‘%1’%2
Sybase Error Code 20766
Sybase SQL Code –1000106L
Local temporary table, %2, must be committed in order to create an index. %1
Sybase Error Code 20767
Sybase SQL Code 1000107L
For table ‘%1’ in join virtual table ‘%2’, \n%3 left outer rows with %4 columns will be moved (inserted/deleted).\n
Sybase Error Code 20768
Sybase SQL Code 1000108L
The DELETE where clause yielded %1 rows, but table ‘%2’ has no data.
Sybase Error Code 20769
Sybase SQL Code 1000109L
For table %1, join index %2 was modified. %3 rows were deleted.
Sybase Error Code 20770
Sybase SQL Code –1000110L
The wrong SIndex has been opened for a fast projection index. %1

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