Page 1 of 1

Pass a parameter for stored procedure in the odbc stage

Posted: Wed Jan 27, 2010 5:25 am
by rhemachandrareddy
Hi,

I have a sybase procedure which is called in the odbc stage.This procedure takes date as a parameter.

ex: exec <procedure name> (parameter). It is working fine in the sybase enviroment.

So now i need to call the procedure in the odbc stage and provide the parameter. But datastage is not identifing the procedure .

how to i reslove the issue. Please let me know if any one the solution

Regards
Hema

Posted: Wed Jan 27, 2010 8:33 am
by chulett
Please be specific as to what your issue is. What exactly does "datastage is not identifying the procedure" mean? Post any errors you are getting.