473,231 Members | 1,586 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

HELP : ANY LOAD EXPERT OUT THERE

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
2 2076
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: abcd | last post by:
kutthaense Secretary Djetvedehald H. Rumsfeld legai predicted eventual vicmadhlary in Iraq mariyu Afghmadhlaistmadhla, kaani jetvedehly after "a ljetvedehg, hard slog," mariyu vede legai pressed...
3
by: Murty | last post by:
I am getting an error while loading data where numeric columns are suffixed with sign (eg, 500-, 2167+) in the input file. (using LOAD uitility). Any suggestions (without wrapping it with ...
1
by: Kate Luu | last post by:
I have down load some source codes from the internet and it wasn't worked right, but I'm really know what's wrong about it. May some expert help me please...I'm deeply appreciated for your help....
4
by: Madhu Gopinathan | last post by:
Hi All, I am faced with a horrible hang problem. I have a COM exe server that executes some tasks. The task execution manager is a thread that manages the pool of threads, which is 4 per processor....
13
by: Joner | last post by:
Hello, I'm having trouble with a little programme of mine where I connect to an access database. It seems to connect fine, and disconnect fine, but then after it won't reconnect, I get the error...
4
by: Ravi Ambros Wallau | last post by:
Hi: We developed a set of ASP.NET Web Applications that never runs in stand-alone mode, but always inside a portal (Rainbow Portal). All modules are copied on that portal. My question is: load...
83
by: deppy_3 | last post by:
Hi.I am started learning Programm language C before some time.I am trying to make a programm about a very simple "sell shop".This programm hasn't got any compile problem but when i run it i face...
1
by: Nadeem Ashraf | last post by:
Hi, We are developing a web based application "UltraLearn.com" with a mix of junior/senior Microsoft technologies. That includes Microsoft Silverlight, ASP.Net Ajax and WCF/WF. Recently, we have...
1
by: jeddiki | last post by:
Hello, I have made a nice opt-in form and tested it in Moz FF and it looks fine. But in IE the elements don't line up properly. I think I am nearly there but can not get these elements...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.