DSXchange

Folks, If you guys are talking regarding passing parameters for the stored procedure as input values, then we can easily achieve this by creating user-defined transforms ans call those transforms in the procedure. this will allow you to given the input values during run-time. rajesh rajesh & Ra...

So you try not to; manage the computation within DataStage using local variables and expressions, and you avoid the latency. Ray can you please explain how this can be achieved through local variables and expressions. Thanks in advance. thanks for the reply. Yes, you are correct regarding the laten...

Hi! I have the same problem... :cry: I've found only one solution which is not great : open the input file (with a job control) to get input values and put them in job parameters of the job that will call ODBC with the stored procedure ( {call stored_procedure(#param1#, #param2#)}; )and get the res...