Remember that flight where the kid behind you would never stop crying or kicked your seat?
Well here is an airplane story of a different color.
Tommy was well-behaved during the entire plane flight. His parents kept him quiet with a handheld game player and a soda. Passengers admired Tommy’s behavior.
But when it was time to leave, Tommy started shouting.
“I DON’T WANNA GO. I GET FREE SODA HERE. MY MOMMY MAKES ME DRINK GREEN STUFF AT HOME.”
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 