Pass a parameter for stored procedure in the odbc stage
Posted: Wed Jan 27, 2010 5:25 am
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
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