View previous topic :: View next topic |
Author |
Message |
analyst Beginner
Joined: 10 May 2007 Posts: 11 Topics: 8
|
Posted: Tue May 17, 2011 4:22 pm Post subject: Conversion of Oracle tables to DB2 tables |
|
|
Our Client is using Oracle on open Systems and DB2 V 8.1 on mainframe.There is requirement in mainframe to select the data on Oracle.
The approach we are following is ask Open Systems to send the data in files and loading them into DB2 tables daily.From mainframe access these DB2 tables.
Is there any easy way using some functions this can be achieved without programming effort. Please let me know if you need any information. |
|
Back to top |
|
 |
superk Advanced

Joined: 19 Dec 2002 Posts: 684 Topics: 5
|
Posted: Tue May 17, 2011 6:33 pm Post subject: |
|
|
I'm somewhat familiar with Oracle, not so much with DB2. I'm not sure what you mean by your comment "Is there any easy way using some functions this can be achieved without programming effort.". Why would there need to be a program involved? Aren't we taling about running a SQL query in Oracle and selecting the rows as needed to a target spool dataset, and then running a batch DB2 load to load those same rows from that dataset? |
|
Back to top |
|
 |
|
|