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

Bulk Load BLOB using DB2 CLI

P: n/a
I want to load multiple rows of BLOB and CLOB into DB2 using CLI. Which
are the possible ways to do it? Any help...

Mar 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Most user interface tools have limited capability to load BLOB/CLOB data
bacause they need an internal buffer to store the data. It wouldn't be
very productive to use a multi gigabyte buffer as a default and then
have users run into available storage issues on smaller systems.

I'd recommend looking at how LOAD works. You can use comma delimited
records for the non-BLOB/CLOB data and references to files containing
the BLOB/CLOB data. There is also a mechanism to allow placing multiple
BLOBs/CLOBs in a single file and having LOAD use a specified portion of
the file for each one to be inserted.

This is all documented in the Command Reference manual.

Phil Sherman
ms*******@gmail.com wrote:
I want to load multiple rows of BLOB and CLOB into DB2 using CLI. Which
are the possible ways to do it? Any help...

Mar 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.