DB2 Databse connect From Oracle Enterprise Stage

vinodn · Post by **vinodn** » Sat Jul 19, 2008 8:25 am

Hi,

We have one requirement as need to connect DB2 database from Oracle Enterprise stage,

Let me know how to do,

chulett · Post by **chulett** » Sat Jul 19, 2008 8:42 am

No, you don't. Perhaps you have a requirement to combine DB2 and Oracle data in a job, but you're not going to be connecting to DB2 from the Oracle Enterprise stage.

vinodn · Post by **vinodn** » Sat Jul 19, 2008 8:59 am

Hi Chulett,

Thanks for your's suggestion,

Actually my requirement is read the data from the Flat file and load the data to DB2 database by using OracleEnterprise datastage,

chulett · Post by **chulett** » Sat Jul 19, 2008 9:50 am

Again, no. Your 'requirement' makes no sense, push back on it. Load it using the DB2 stage... or perhaps ODBC but certainly not with the Oracle stage.

ArndW · Post by **ArndW** » Sat Jul 19, 2008 10:00 am

vinodn - that requirement is like your company buying DataStage but demanding you use Informatica to load your data. The Oracle stage is used to connect to Oracle, the DB2 Stage is used to connect to DB2 and neither database is accessible from a Teredata stage.