Unknown SQLCODE error
Art Kagel asked what SQL error -1831 means when fetching an sqlda cursor in dbcopy.ec on a four-column table with an LVARCHAR. Doug Lawry pointed to an APAR, and Jonathan Leffler said it means FetArrSize, deferred-PREPARE and OPTOFC cannot be combined. Art said he used none of those, only an array fetch with LVARCHAR, a known bug since CSDK 3.10 and unfixed in 3.70.xC1B6.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
>