Hi Folks,
I have a table "create table test_tbl (c1 int, c2 clob(200k))". Some how,it not allowing me to insert more than 32 K. Is there any parameter to set?.
Thanks
--chandra

What method do you use to insert your data? What kind of error message you get when 'it not allowing me to insert'?

Hi!
I use plain db2 "insert into <table> values(10,'big string')
I would like to insert "big string" about 200 K. I get following error when i insert more than 32K.

SQL0102N The string constant beginning with "'blah blah ....'" is too long. SQLSTATE=54002

Thanks
--chandra

That sort of explains a lot, doesn't it? In case it doesn't, try typing "? SQL0102N" in Command Line Processor. I bet you'll see something like this:

Thank you. I wil try with CLI..

if you do not want to write a program you might try to use SQL UPDATE to concat a string to the already existing content of the CLOB.
DB2 SQL can handle long strings, and this method avoids that the CLOB content has to be materialized outside the SQL engine.

Heinz:

I'm having the same problem...could you provide a little more detail on your proposed solution?

Thanks!