Re: How to send error back?
Surprisingly, it really depends on the language of the calling program. For example, in Java you would call SQLException.getErrorCode() and SQLException.getMessage(). In C I imagine you could read SQLCA structure.
Originally posted by ngutta
How can I send SQL exception message and code from Stored Procedure back to calling program
You may want to RTF DB2 Application Development Guide for details.
Hope this helps.
"It does not work" is not a valid problem statement.