capturing the stored procedure log
Posted: Wed Sep 04, 2013 9:54 am
Hi,
I am using one stored procedure in the datastage job which loads the data from one layer to another layer.
The design is
row generator -----stored procedure stage----peek stage
I had an issue in the stored procedure it failed because of the "Violation of UNIQUE KEY constraint" but in the log there was no message and the job went successful.
Now I want to make the design thechange to abort the job when ever there is an issue in the stored procedure.
Please suggest how to do that.
I am using one stored procedure in the datastage job which loads the data from one layer to another layer.
The design is
row generator -----stored procedure stage----peek stage
I had an issue in the stored procedure it failed because of the "Violation of UNIQUE KEY constraint" but in the log there was no message and the job went successful.
Now I want to make the design thechange to abort the job when ever there is an issue in the stored procedure.
Please suggest how to do that.