467,154 Members | 881 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

Bulk Load BLOB using DB2 CLI

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
  • viewed: 3154
Share:
1 Reply
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.

Similar topics

1 post views Thread by picaza | last post: by
2 posts views Thread by Chris | last post: by
2 posts views Thread by David Sharp | last post: by
2 posts views Thread by php newbie | last post: by
2 posts views Thread by Niraj | last post: by
5 posts views Thread by Sumanth | last post: by
11 posts views Thread by Ted | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.