DSXchange

Hi,

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

Let me know how to do,

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.

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,

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.

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.