Moving CLOB data from OS/390 DB2 to UDB V 8.2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

beena - 16 Mar 2005 19:17 GMT

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...

Reply to this Message

Ian - 16 Mar 2005 19:40 GMT

> We have a mainframe DB2 table with CLOB data type...
>
[quoted text clipped - 7 lines]
>
> Any suggestions...

Use "load from file of ASC MODIFIED BY RECLEN=xxx ..."

Reply to this Message

pshindle@comcast.net - 18 Mar 2005 17:34 GMT

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

> We have a mainframe DB2 table with CLOB data type...
>
[quoted text clipped - 7 lines]
>
> Any suggestions...

Reply to this Message