MVSFORUMS.com

[viswanathan]

In our program the input is declared as CLOB of size 128000. We are getting XML file from front end(DOTNET) as input and we parse this XML and use the data. We are doing insert and updates in various tables.

The problem is arising when the input is more than 32K bytes.
We are getting the data from front end , In WLM displays it is showing that it is successfully parsed and the required tables are inserted or updated successfully. But in the database , tables are not getting inserted or updated.

In the front end we are getting the following error mesage.
Failed to upload file. Cause: ERROR [07006] [IBM] CLI0102E Invalid conversion. SQLSTATE=07006

NOTE:

If the input is less than 32K every thing is working fine i.e tables are getting inserted or updated and we are getting successfull message in the front end.

Please help us in overcoming the above issue.

[kolusu]

viswanathan,


Check this

http://www-01.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q=CLI0102E+&uid=swg1JR17689&loc=en_US&cs=utf-8&lang=en

Kolusu

[viswanathan]

Thanks for the info Kolusu!