hi
how to access parameters returned by stored procedure in DataStage
for eg. wwprt.calculateREAL(OUT int, OUT varchar(50)) is the signature of stored procedure and i hv t dev job which will do the following
1.2.1. If the call to DB2 stored procedure fails, write error details to application log, and send e-mail to Operations
1.2.2. If the OUT int variable contains a non-zero value
1.2.2.1. Write error details, including both int return code and varchar(50) error text, to the application log
1.2.2.2. Send an e-mail to operations, including both int return code and varchar(50) error text.
how to do this?mailing part i know but how to handle these parameters?
(stored procedure is not taking any input just have two output parameter to return error code if any)
working with Stored Procedure in DataStage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
Hi,
Can you elaborate more on:
What DB2 Version you use?
What specific version of DS?
What stage are you using?
Most important, what did you try and what errors did you get?
Can you elaborate more on:
What DB2 Version you use?
What specific version of DS?
What stage are you using?
Most important, what did you try and what errors did you get?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org