DSXchange

hi ,

can any-body guide me on how to call a stored procedure in datastage with INPUT parameter?

Right now I regeister procedure in datastage,but it's giving me 0 rows in datastage ,

however If i ran same procedure in backend it rans successfully and return rows ..

Hi,

You can use Stored Procedure stage, Use SP stage as transform stage so that you can provide Input values and get output values.

thanks,
Waseem

In Stored Procedure stage, you have option called Forward Row Data, i think you need to set that.
I am not sure are you looking for the same solution or not.
I worked on Stored Procedures long back, Plz chk. out, this might what you want.

Hello,

My understanding says u want to provide a input value and get the output records it means you want to send record to SP stage and get the records from SP stage, if so then make the procedure type (comes under syntax tab) as Transform so that u make it to send and receive the records.

Thanks,
Waseem

hi wasim,
right now i m using ODBC stage where I registered a SP .
JOB flow is like this ODBC---->Transformer---> SEQ FILE
when I run the job I set the parameter in job properties
Job accepts the date parameter but prob is that it runs and gives 0 rows instead i cross checked with backend for same date criteria it gives records

What database? Suggest you read the Additional Database Specifics section of the stpstage.pdf document for your particular database.

Hi I am new to this site.

can you please let me know where can I get stpstage.pdf please?

In the old days (you did respond to a 10 year old post) they installed with the client software pdf versions of all of the documentation you needed. Nowadays it's all online and for example, a quick Google search for something like "DataStage stored procedure stage" turns this up, amongst other things. All versions should be out there, I just picked this one at random, hoping your installed version was fairly current. And you can see a link at the bottom to download a pdf version should you so desire.