Help : Any Load Expert Out There

[Naive]

I am a newbie in db2.
We have a table CLOBTAB defined as

CREATE TABLE CLOBTAB(COL CLOB(2M))

We are trying to load a file of around 1 MB into this table using load command. The file is deos not have a record delimiter as we want this complete data as one record in the table.

The load command is as follows:

LOAD FROM C:\FILENAME.TXT OF DEL LOBS FROM C:\ MODIFIED BY LOBSINFILE INSERT INTO CLOBTAB

It gives the following error:

SQL3115W The field value beginning "startxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" in row
"1" and column "1" is longer than the longest allowable table column. The value was truncated.

Is there any solution to this error or is there any workaround for this? Any help would be greatly appreciated.
Thanks in advance

[lreina]

Hi,

In the C:\FILENAME.TXT you just have to put the name of the file NOT the contents of the data.


Luis Reina