DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
qutesanju
Participant



Joined: 26 Aug 2008
Posts: 373

Points: 2946

Post Posted: Fri Nov 28, 2008 1:57 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Server
OS: Windows
Additional info: how to call a stored proc having only INPUT parameter
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



Joined: 19 Jan 2007
Posts: 19
Location: bangalore
Points: 97

Post Posted: Fri Nov 28, 2008 3:52 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
yousuff1710
Participant



Joined: 21 Sep 2007
Posts: 56
Location: Bangalore
Points: 407

Post Posted: Fri Nov 28, 2008 4:30 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
syeed
Participant



Joined: 19 Jan 2007
Posts: 19
Location: bangalore
Points: 97

Post Posted: Fri Nov 28, 2008 4:39 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
qutesanju
Participant



Joined: 26 Aug 2008
Posts: 373

Points: 2946

Post Posted: Fri Nov 28, 2008 6:08 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42530
Location: Denver, CO
Points: 218857

Post Posted: Fri Nov 28, 2008 8:58 am Reply with quote    Back to top    

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

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
Kishore.Voonna
Participant



Joined: 31 Jan 2018
Posts: 1

Points: 3

Post Posted: Wed Jan 31, 2018 6:59 pm Reply with quote    Back to top    

Hi I am new to this site.

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

_________________
KishoreVoonna
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42530
Location: Denver, CO
Points: 218857

Post Posted: Wed Jan 31, 2018 11:02 pm Reply with quote    Back to top    

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

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours