Re: Unknown SQLCODE error
Posted in 2010
On Wed, Sep 15, 2010 at 5:47 PM, Art Kagel <art.kagel@gmail.com> wrote:
> 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.
>>
>
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...