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 ..
how to call stored procedure having only IN parameter in DS
Moderators: chulett, rschirm, roy
Re: how to call stored procedure having only IN parameter in
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
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
Syed
---------
Wait and Watch
---------
Wait and Watch
-
- Participant
- Posts: 56
- Joined: Fri Sep 21, 2007 9:10 am
- Location: Bangalore
Re: how to call stored procedure having only IN parameter in
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.
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.
Re: how to call stored procedure having only IN parameter in
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
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
Syed
---------
Wait and Watch
---------
Wait and Watch
hi wasim
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
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
-
- Participant
- Posts: 1
- Joined: Wed Jan 31, 2018 6:53 pm
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers