Call sqlserver procedure from datastage

[sangi1981]

Hi all and thanks in advance.
I'm developing a parallel job that has to invoke a sqlserver procedure.
So I use Stored Procedure stage, but I have some problem.

Design of my job is: column_generator->transformer->stored_procedure.
In column generator i create one row to create a stream.
In transformer I set input parameter values of procedure.
In sp I call procedure.
This procedure has two input parameter and an output. Input parameters are an integer and a varchar(255). Output is integer.

When I run job, I obtain following errors: [DataDirect][ODBC lib] Invalid argument value.

Can I omitt output stream in stored procedure or is it necessary?

Best regards

[devo]

I am adding a link to this post in case this is your issue. Apparently there is an issue if you use an isolation level = "none" for a stored procedure. Switching this to read committed fix this for me like magic.

https://www-304.ibm.com/support/docview ... wg21404686