Pass a parameter for stored procedure in the odbc stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rhemachandrareddy
Participant
Posts: 1
Joined: Thu Nov 19, 2009 7:57 am

Pass a parameter for stored procedure in the odbc stage

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply