View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 03:49 AM
Nina via DBMonster.com
 
Posts: n/a
Default Insert CLOB / BLOB


Hi,
I'm trying to insert a clob / blob from the local file system into a basic
table. This can be quite easily accomplished in Oracle but I have not found
any wquivalent way on how to do this in DB2. I have the following table:

create table docs(
doc_id integer,
docs clob(),
constraint pk PRIMARY KEY (doc_id))

The documents that i want to insert into clobs are located at the c drive
so the path is "c:/docs"

I would really appreciate any help here.
BTW: I want to do this without using any external programming language.

Nina

--
Message posted via http://www.dbmonster.com
Reply With Quote