Skip to main content

developerworkslabel >  Information Management  >  forumlabel  >  DB2 Express  >  developerWorks

db2 load csv file with clob data    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

loginbox.header
 loginbox.welcomelabel loginbox.guestlabel
loginbox.signin
Permlink Replies: 0 - Pages: 1
locojay

Posts: 1
Registered: Oct 15, 2009 02:35:22 PM
db2 load csv file with clob data
Posted: Oct 15, 2009 02:38:20 PM
Click to report abuse...   Click to reply to this thread Reply
Hi
i am tring to load a csv file to a db2 table with a clob. The clob in the csv contains new line chars. I get the following error:
SQL3116W The field value in row "11" and column "61" is missing, but the
target column is not nullable.

The thing is that i limited the load to only load one row of the file. My load is load
load
from xxxx
of del
MODIFIED BY LOBSINFILE COLDEL, USEDEFAULTS CHARDEL"" DELPRIORITYCHAR
method P (x,x,x,x)
ROWCOUNT 1
insert into
tablename(x,x,x,x);

any idea? The java migration tool seems to store clob data in separate files. Is this a must?
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums