Hi

When I am trying to insert a huge Text String in to the Clob Column. I am getting the following

SQL0102N The string constant beginning with "'SELECT... " is too long.

Since the String i am trying to insert is too large, I broke them into two separate strings and try to insert it, but still i am getting the same error.

Following is the code we try to concat two large string and stored it in CLOB column.

BEGIN ATOMIC
declare txt1 varchar(30000);
declare txt2 varchar(30000);

set txt1 = 'Large Text 1......';
set txt2 = 'Large Text 2...... ';
insert into test1 values (concat(txt1,txt2));
END

maybe this
The string constant beginning with string has a length greater than 32672 bytes. Character strings with lengths greater than 32672 bytes or graphic strings with lengths greater than 16336 characters can be specified only through assignment from host variables. Note that other servers in the DB2 family of products may specify a different size limit for character strings. Consult the documentation for the appropriate DB2 product for details.
SQL0102N

Thanks for you reply. Can you give me an example of using host variables?
I am from Oracle background.

yes I could - but .. this is a justification to try to understand db2
have a look at the doc and try to understand
https://www-304.ibm.com/support/docv...id=swg27015148
or check the sample directory in db2 installation where you will find many samples..