How to pass values to parameters in ( ODBC SP datastage)
Posted: Tue Nov 15, 2005 1:27 pm
Hi
I am calling Stored Procedure using ODBC (select using Stored Procedure),
In Parameters Tab there are 4 Input variables starting with @, and Column tab there are 2 columns mapping to output seqfile.
when i run the job it is not asking for values of parameters.
but when i remove the @symbol , if i give the values for variables then it is working fine.
My question is How to pass the values to variables in odbc.
Thanks
I am calling Stored Procedure using ODBC (select using Stored Procedure),
In Parameters Tab there are 4 Input variables starting with @, and Column tab there are 2 columns mapping to output seqfile.
when i run the job it is not asking for values of parameters.
but when i remove the @symbol , if i give the values for variables then it is working fine.
My question is How to pass the values to variables in odbc.
Thanks