Stored Procedure interface after a severe DB2 error

[login to unmask email]

Stored Procedure interface after a severe DB2 error
Can the passed parameters be kept intact after a severe error occurs? We
what to use the ROLLBACK command within a SP but also pass back the reason
for the request. Can it be done using DB2 5.1 level?
*******************Internet Email Confidentiality Footer*******************


Privileged/Confidential Information may be contained in this message. If
you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone. In such case, you should destroy this message and kindly
notify the sender by reply email. Please advise immediately if you or your
employer do not consent to Internet email for messages of this kind.
Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by it.



Roger Miller

Re: Stored Procedure interface after a severe DB2 error
(in response to robert.j.hartmann@US.ARTHURANDERSEN.COM)
COMMIT and ROLLBACK are not permitted in a stored procedure until V7, and
that would roll back the stored procedure and all other processing.
You might want to check on the savepoints added in a V6 APAR, so that you
roll back to a save point at the beginning of the stored procedure.
V5 has none of the above, but you can chase through the stored procedure
red book SG24-4693 for ROLLBACK to see older functions.

Roger Miller, DB2 for OS/390