how to call stored procedure having only IN parameter in DS

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
qutesanju
Participant
Posts: 373
Joined: Tue Aug 26, 2008 4:52 am

how to call stored procedure having only IN parameter in DS

Post by qutesanju »

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 ..
syeed
Participant
Posts: 19
Joined: Fri Jan 19, 2007 12:35 am
Location: bangalore

Re: how to call stored procedure having only IN parameter in

Post by syeed »

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
Syed
---------
Wait and Watch
yousuff1710
Participant
Posts: 56
Joined: Fri Sep 21, 2007 9:10 am
Location: Bangalore

Re: how to call stored procedure having only IN parameter in

Post by yousuff1710 »

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.
syeed
Participant
Posts: 19
Joined: Fri Jan 19, 2007 12:35 am
Location: bangalore

Re: how to call stored procedure having only IN parameter in

Post by syeed »

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
Syed
---------
Wait and Watch
qutesanju
Participant
Posts: 373
Joined: Tue Aug 26, 2008 4:52 am

hi wasim

Post by qutesanju »

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

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Kishore.Voonna
Participant
Posts: 1
Joined: Wed Jan 31, 2018 6:53 pm

Post by Kishore.Voonna »

Hi I am new to this site.

can you please let me know where can I get stpstage.pdf please?
KishoreVoonna
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Post Reply