call database after cdc stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
and
Participant
Posts: 14
Joined: Thu Oct 05, 2017 5:36 am

call database after cdc stage

Post by and »

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

Post by chulett »

"2 step"?
-craig

"You can never have too many knives" -- Logan Nine Fingers
and
Participant
Posts: 14
Joined: Thu Oct 05, 2017 5:36 am

Post by and »

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

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply