DSXchange

I have a Sybase stored procedure which does insert in 3 tables. I am calling the stored procedure using SYBASE OC stage.

I need to capture Successful completion or custom error code and message thrown by the stored procedure . These informations are inserted in the tracking table.

I am using Following to generate custom error
All these message are getting logged in Datastage Log.

Thanks in advance!

You need to build in a return code and catch all the throws and handle it within that.

You need to build in a return code and catch all the throws and handle it within that.

Jus pass the error message back with a variable. Then try inserting the variable to the required table.