How to pass values to parameters in ( ODBC SP datastage)

harithay · Post by **harithay** » 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

harithay · Post by **harithay** » Tue Nov 15, 2005 2:33 pm

Thanks

I got it.