I was tring to insert a clob object into DB2 v 7.2 from my web site by executing a INSERT statement and running into a problem when I execute.

It appears that the my SQL statment is getting Truncated, or is reaching some size limit...

How could I check this? or is there a better way of insterting CLOB into a remote db?

Thanks Inadvance

There's a limit of 32K bytes on the length of string literals - may be this is your problem. You can try to work around this limitation by concatenating together several literal strings, each of them being shorter than 32K. However, you'll hit the 64K limit on the length of a SQL statement.

A proper way to work with LOBs depends on the programming language you use. In java, you would use PreparedStatement.setCharacterStream()

I am current using Microsofts ADO object. Would anybody have some sample code that does this java evquivalent?

See if this gives you any hints:

http://publib.boulder.ibm.com/infoce...d/t0007411.htm