Does anyone know what SQL error -1831 is? It is not showing up in finderr
(not even in Panther). It's connected with fetching a cursor using an sqlda
descriptor structure, but I don't know what's wrong. This is well tested
code (dbcopy.ec) and a simple table with four columns a DATETIME YEAR TO
SECOND, a CHAR(32), a CHAR(12), and an LVARCHAR(2048).

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

Hi Art.

It might well be related to this:

http://www-01.ibm.com/support/docvie...id=swg1IC50423

Cheers,
Doug

On Sep 14, 9:46*am, Art Kagel <art.ka... (AT) gmail (DOT) com> wrote:

-1831: Combination of FetArrSize Deferred-PREPARE and OPTOFC is not
supported.


From an 11.50.FC6 installation.

Ya, but I'm not using Deferred Prepare OR OPTOFC optimizations, just an
ARRAY FETCH of a table with an LVARCHAR. Apparently a known bug since CSDK
3.10.xC1 that's still not fixed as of CSDK 3.70.xC1B6.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Wed, Sep 15, 2010 at 12:31 PM, Jonathan Leffler <
jonathan.leffler (AT) gmail (DOT) com> wrote:

On Wed, Sep 15, 2010 at 5:47 PM, Art Kagel <art.kagel (AT) gmail (DOT) com> wrote:

Art,

The reference I've found was fixed. It can be another problem with the same
symptoms. Or a bad fix of course, but we can't assume that without further
analysis.
I'd suggest that you open a PMR, specially if you have a test case...

Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...