View previous topic :: View next topic
|
Author |
Message |
deepti sinha
New User
Joined: 08 Jan 2008 Posts: 2 Location: india
|
|
|
|
how to load mass data from oracle to DB2 for mainframes with the same table structure. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Deepti,
Oracle and DB2 for MF are different prodcuts which run on diff systems. To my knowledge, its not possible. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Deepti,
It seems Im wrong with my prev post. There are tools availabel, google it.
Can provide you the proper search word, you can try with 'Data Replicator'. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Quote: |
Can provide you the proper search word |
Read as 'Cant provide....' |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Yeah I got it. It is -
DB2 DATA PROPOGATOR. |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
|
|
Deepti,
Try exporting your oracle table in form of text (Formatted TEXT;CSV) into a text file first and then FTP the file on to the mainframes and the same file then can be used in the load utility to load the data into the table having same structure as of oracle table. |
|
Back to top |
|
|
|