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



Joined: 05 Oct 2017
Posts: 14

Points: 160

Post Posted: Fri Nov 17, 2017 2:42 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
hi all

i have cdc stage in my job and after job will be invoked i need to call some sql statement in database ( oracle ) and pass/get data from

1 cdc -> 2 call db -> 3 process some logic -> 4 call target

i'm interested in 2 step
how to implement 2 step for calling database
is it routine ? with oci call ?


thanks
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42622
Location: Denver, CO
Points: 219444

Post Posted: Fri Nov 17, 2017 5:45 am Reply with quote    Back to top    

"2 step"?

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
and
Participant



Joined: 05 Oct 2017
Posts: 14

Points: 160

Post Posted: Sat Nov 18, 2017 12:17 am Reply with quote    Back to top    

hi
yes

1 cdc -> 2 call db -> 3 process some logic -> 4 call target

i need call db with data from cdc stage and return some data from then
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: 42622
Location: Denver, CO
Points: 219444

Post Posted: Mon Nov 20, 2017 1:19 pm Reply with quote    Back to top    

Well... just repeating everything doesn't help all that much but if "2 step" means you need help with Step #2 you'll need two jobs for that AFAIK. Unless something has changed in the architecture since last I used the product, a connector can be either a source OR a target but not both. So, 1 and 2 would need to be one job and then 2 again to "return some data" along with 3 and 4 in another job.

If that's not feasible in your case, we'd need specifics as to the "why not" of it in order to help, I would imagine.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54259
Location: Sydney, Australia
Points: 294280

Post Posted: Tue Nov 21, 2017 3:06 am Reply with quote    Back to top    

If step 2 were a call to a stored procedure that returned a value, then you might be able to implement it all in the one DataStage job.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
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