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
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.