Unknown SQLCODE error

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@iiug.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/docview.wss?uid=swg1IC50423 Cheers, Doug

On Sep 14, 9:46 am, Art Kagel <art.ka...@gmail.com> wrote: > 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). -1831: Combination of FetArrSize Deferred-PREPARE and OPTOFC is not supported.

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@iiug.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@gmail.com> wrote: > On Sep 14, 9:46 am, Art Kagel <art.ka...@gmail.com> wrote: > > 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). > > > -1831: Combination of FetArrSize Deferred-PREPARE and OPTOFC is not > supported.> > > >From an 11.50.FC6 installation. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >