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)
