Problem: Need to distinguish between Sybase RDBMS related exceptions and user data exceptions .
Solution: Since Sybase uses error numbers less than 2000, you can choose to use numbers larger than 3000. You can control the returned error code by using the raiserror function. Yes that is not a misspelling.
Note: Sybase with many of its functions, tried to save keystrokes by eliminating duplicate characters. Here Sybase did not allow double “e”s but left the double “r”s in. Oh well.
For more info see http://stackoverflow.com/questions/7482383/distinguish-sybase-expections-types
Good SQL. Good night.
Michael E Kelley 