By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,837 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,837 IT Pros & Developers. It's quick & easy.

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

P: n/a
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...

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
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...


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

Nov 12 '05 #2

P: n/a
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...


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.