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.T XT"
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
"startxxxxxxxxx xxxxxxxxxxxxxxx xxxxx" 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
