Can DS JOB read Oracle DB and write to MVS DB2?

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
Julja
Participant
Posts: 3
Joined: Wed Jun 14, 2006 9:47 am
Location: Toronto

Can DS JOB read Oracle DB and write to MVS DB2?

Post by Julja »

Hi,
we need to extract data from Oracle Data Base and load it into Mainframe DB2 tables. Is it possible to do in DS Server JOB? We started working with DS MVS, but now are considering using DS Server or DS Enterprise. It is very important for us to know if we can connect to two different Data Bases in the same JOB.
Please help :?:
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I can't speak to the specifics of 'Mainframe DB2 tables', but the general answer to the question 'can we connect to two different databases in the same job' is - heck, yah - you betcha. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply