× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. September 2013

Re: Stored Procedure with a very large data type

On 17 Sep 2013 11:10, RPGLIST wrote:
One of our c# programmers is attempting to call a stored procedure
and pass me a large data set (approx 60,000 bytes) in a field defined
as a CLOB (iSeries DB2) but we're getting an SQL error that the
string length is too long, but I believe that a CLOB has a max size
of 2gb,

The error is: "String constant beginning with .1.....' too long.
Cause: The string constant beginning with .1...." is larger than
32740.

Suggestions?

My first suggestion is to choose a more appropriate forum. As described, that SQL0102 has nothing to do with a host language.

Second... the limit to the length of a string literal is irrespective of the use\declaration of a LOB. The caller should use a LOB variable rather than a simple scalar literal *character string* as the argument for the CLOB parameter.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.