By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

HELP : ANY LOAD EXPERT OUT THERE

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You don't need an expert, you need a copy of the command reference and a
good read of the LOAD command.

LOBSINFILE means that the LOBs are contained in file(s) and that the
file being loaded contains references to the files containing the LOBs.
OF DEL means that the data in the file being loaded is delimited using
"standard" delimiters.

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

File LOBLOC.TXT contains one record, with the following content:
"FILENAME.TXT"

An interesting question is why you have a table consisting of a single
CLOB column. Unless you will have a table containing one row, how do you
intend to select which row to process? I'd think that scanning this
table to find a specific CLOB would not be a good performer.

Phil Sherman

ab****************@wipro.com wrote:
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

Nov 12 '05 #2

P: n/a
Hi Phil ,
Thanks a lot about the approach that u have shown us in moving this
further.
That was perfectly the right thing that i was looking for.Now its
working perfectly fine.

Thanks again
Abhishek.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.