Troubleshooting Sybase Error Code from Error 0 and 102

SQLServerF1

Sybase Error Code 0
SQL Code –631
RAISERROR executed: %1
Sybase Error Code 102
SQL Code –171
Error opening cursor
Sybase Error Code 102
SQL Code –199
INSERT/DELETE on cursor can modify only one table
Sybase Error Code 102
SQL Code –933
A log is required for IQ databases
Sybase Error Code 102
SQL Code –275
Triggers and procedures not supported in runtime server

Sybase Error Code 102
SQL Code –273
COMMIT/ROLLBACK not allowed within trigger actions
Sybase Error Code 102
SQL Code –131
Syntax error near ‘%1’ %2
Sybase Error Code 102
SQL Code –687
Syntax error, cannot specify IQ specific options without specifying IQ PATH
Sybase Error Code 102
SQL Code –875
There is no way to join to ‘%1’
Sybase Error Code 102

SQL Code –145
Foreign key name ‘%1’ not found
Sybase Error Code 102
SQL Code –271
Trigger definition conflicts with existing triggers
Sybase Error Code 102
SQL Code –272
Invalid REFERENCES clause in trigger definition
Sybase Error Code 102
SQL Code –635
GRANT of column permission on view not allowed
Sybase Error Code 102
SQL Code –151
Subquery allowed only one select list item
Sybase Error Code 102
SQL Code –269
Cannot delete a column referenced in a trigger definition

Above are list of Sybase Error Code Messages from Error Code 0 and Error Code 102 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 *