Stored Procedure Return Code

Stored Procedure Return Code

 

  

Does UDB store a return code or result set in a system table that can be
interrogated after execution? Executing a UDB stored procedure from
Microsoft Integration Services doesn't seem to support the required
syntax to grab the return value from the stored procedure itself. I
could create and update my own success / failure table but didn't want
to if it wasn't necessary.



Thanks.



Rob Koves
Database Administrator
FedEx National LTL

1.863.603.5480 TEL

1.863.581.0945 CEL

Rob.[Email address protected]





******************NOTICE*******************
This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s) only and may contain privileged, confidential, work-product and/or trade secret information of a proprietary nature. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, distribution or re-transmission of this e-mail or any attachment(s) is strictly prohibited and that all rights of the sender and/or intended recipients are hereby reserved without prejudice thereto.

DB2 & UDB email list listserv db2-l LazyDBA home page