Call sqlserver procedure from datastage
Posted: Mon Jun 20, 2011 9:27 am
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
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