Hi -
I believe that as long as you have DB2 Connect you can use the EXPORT
utility to read the LOB from DB2/Zos (LOB data flows over a DRDA data
stream) and then use the IMPORT utility to UDB. I'm not sure if the
table structures have to match though... It's worth a shot. Please
reply back when you find your solution - it would be valuable for
others to know how to do this. Thanks.
Perry Shindle
beena wrote:
We have a mainframe DB2 table with CLOB data type...
What's the best way to transfer CLOB data from os/390 DB2
to UDB (8.2) on AIX 5.2.
We tried unloading data with fixed format and tried loading in UDB
using Method L.
Unloaded CLOB field seems to have \n which causes confusion with
the row delimitor (\n)...
Any suggestions...