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
Call sqlserver procedure from datastage
Moderators: chulett, rschirm, roy
Re: Call sqlserver procedure from datastage
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
https://www-304.ibm.com/support/docview ... wg21404686