How do you want this data to be stored on Mainframe? In files or into Oracle or DB2? If lobs are small than you can extract them as part of the row.
If there is not much data to transfer then spool it. Otherwise use wisdomforce fastreader wisdomforce.com to extract data into text and create automatic loader for target.


Quote Originally Posted by Horace
Hi,

One of our clients has an Oracle database with CLOBs and BLOBs.

We need to load this information into one of our Mainframe systems.

Can anyone offer any advise as to how to do this? What is the best conversion?

Many thanks