BLOB/CLOB conversion for mainframe

[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

[TimHall]

Hi.

You could export them as files and load them into the mainframe:

http://www.oracle-base.com/articles/8i/ExportClob.php
http://www.oracle-base.com/articles/8i/ExportBlob.php
http://www.oracle-base.com/articles/9i/ExportBlob9i.php

A CLOB is just plain text, so this shouldn't represent a problem. BLOBs on the other hand may be a proprietry format, like Word or PDF, or just a random stream of bytes. Although you can store the binary, doing anything useful with it may not be possible without the relevant programs to display the format being stored.

Cheers

Tim...

[ixion]

Try IxUnload it will unload blob/clob columns. Either Merged into a single large file or into individual files (1 per row per blob).

[dbaman123]

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.

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