Unknown SQLCODE error
Art Kagel hit an undocumented SQL error -1831 (not listed in finderr) while fetching a cursor via an sqlda descriptor in his dbcopy.ec code, against a table containing DATETIME, CHAR and LVARCHAR(2048) columns, on IDS/CSDK 11.50.FC7 and 11.70.FC1B6 on 64-bit Ubuntu. One suggestion was to run 'strings' on oninit and grep for the code, which turned up nothing. Fernando Nunes said internal references tie -1831 to array (buffered) fetch combined with LVARCHAR, citing older APAR IC50423 reportedly fixed in CSDK 3.0, and suggested trying without OPTOFC — but Art had OPTOFC unset. No resolution is recorded; the thread drifts into jokes about Art's mistyped version numbers and Informix release history.
Auto-generated by DrWatson 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. --00163628363638f0bf04903af4b1
Did you try doing a 'strings' on the oninit executable and grep for it?
Bob
----- Original Message -----
From: "Art Kagel" <art.kagel@gmail.com>
To: ids@iiug.org
Sent: Tuesday, September 14, 2010 12:46:32 PM
Subject: Unknown SQLCODE error [21280]
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.
--00163628363638f0bf04903af4b1
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > > 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. > > --00163628363638f0bf04903af4b1 > Shame on you! You should always post your versions! :) Just joking. There are some internal references to it and a bug in CSDK 3.00. I would need more time to check this, but it's related to using fetch array and LVARCHAR. If you have OPTOFC set, try without it. There was an APAR IC50423 related to this, but it looks relatively old (2007). Some references found in a bug supposedly fixed on CSDK 3.0... Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001636283a7c528a7d04903b3d1d
Grep for what? 1831? Not found.
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 Tue, Sep 14, 2010 at 12:51 PM, rroussey@comcast.net <rroussey@comcast.net
> wrote:
> Did you try doing a 'strings' on the oninit executable and grep for it?
>
> Bob
>
> ----- Original Message -----
> From: "Art Kagel" <art.kagel@gmail.com>
> To: ids@iiug.org
> Sent: Tuesday, September 14, 2010 12:46:32 PM
> Subject: Unknown SQLCODE error [21280]
>
> 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.
>
> --00163628363638f0bf04903af4b1
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016362839aae2a8ff04903b7059
You are correct Fernando. I have vigorously slapped both of my hands. Versions: CSDK v 3.50.FC7 & 3.70.FC1B6 IDS 3.50.FC7 & 3.70.FC1B6 Ubuntu 9.04 Linux 64bit OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes <domusonline@gmail.com>wrote: > On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > > > > 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. > > > > --00163628363638f0bf04903af4b1 > > > > Shame on you! You should always post your versions! :) Just joking. > There are some internal references to it and a bug in CSDK 3.00. I would > need more time to check this, but it's related to using fetch array and > LVARCHAR. > If you have OPTOFC set, try without it. > > There was an APAR IC50423 related to this, but it looks relatively old > (2007). Some references found in a bug supposedly fixed on CSDK 3.0... > > Regards. > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001636283a7c528a7d04903b3d1d > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e889ec371e304903b9dca
Art: Being that you are running a release of Informix Server that is about 18 years old, we would like to ask that you upgrade soon. -:) > CSDK v 3.50.FC7 & 3.70.FC1B6 > IDS 3.50.FC7 & 3.70.FC1B6 > Ubuntu 9.04 Linux 64bit John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > [image removed] > > Re: Unknown SQLCODE error [21284] > > Art Kagel > > to: > > ids > > 09/14/2010 10:37 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > You are correct Fernando. I have vigorously slapped both of my hands. > Versions: > > CSDK v 3.50.FC7 & 3.70.FC1B6 > IDS 3.50.FC7 & 3.70.FC1B6 > Ubuntu 9.04 Linux 64bit > > OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. > > 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes <domusonline@gmail.com>wrote: > > > On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > > > > > > 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. > > > > > > --00163628363638f0bf04903af4b1 > > > > > > > Shame on you! You should always post your versions! :) Just joking. > > There are some internal references to it and a bug in CSDK 3.00. I would > > need more time to check this, but it's related to using fetch array and > > LVARCHAR. > > If you have OPTOFC set, try without it. > > > > There was an APAR IC50423 related to this, but it looks relatively old > > (2007). Some references found in a bug supposedly fixed on CSDK 3.0... > > > > Regards. > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --001636283a7c528a7d04903b3d1d > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0016361e889ec371e304903b9dca > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA OK, 11.50.FC7 & 11.70.FC1B6, wise acre. ;-) 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 Tue, Sep 14, 2010 at 4:37 PM, John Miller iii <miller3@us.ibm.com> wrote: > Art: > > Being that you are running a release of Informix Server that is about 18 > years old, > we would like to ask that you upgrade soon. -:) > > > CSDK v 3.50.FC7 & 3.70.FC1B6 > > IDS 3.50.FC7 & 3.70.FC1B6 > > Ubuntu 9.04 Linux 64bit > > John F. Miller III > STSM, Embedability Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > > > [image removed] > > > > Re: Unknown SQLCODE error [21284] > > > > Art Kagel > > > > to: > > > > ids > > > > 09/14/2010 10:37 AM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids > > > > You are correct Fernando. I have vigorously slapped both of my hands. > > Versions: > > > > CSDK v 3.50.FC7 & 3.70.FC1B6 > > IDS 3.50.FC7 & 3.70.FC1B6 > > Ubuntu 9.04 Linux 64bit > > > > OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. > > > > 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes > <domusonline@gmail.com>wrote: > > > > > On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > > > > > > > > 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. > > > > > > > > --00163628363638f0bf04903af4b1 > > > > > > > > > > Shame on you! You should always post your versions! :) Just joking. > > > There are some internal references to it and a bug in CSDK 3.00. I > would > > > need more time to check this, but it's related to using fetch array and > > > > LVARCHAR. > > > If you have OPTOFC set, try without it. > > > > > > There was an APAR IC50423 related to this, but it looks relatively old > > > (2007). Some references found in a bug supposedly fixed on CSDK 3.0... > > > > > > Regards. > > > -- > > > Fernando Nunes > > > Portugal > > > > > > http://informix-technology.blogspot.com > > > My email works... but I don't check it frequently... > > > > > > --001636283a7c528a7d04903b3d1d > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --0016361e889ec371e304903b9dca > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd32f6214b9f304903e3cba
3.50.FC7??? Did they even have 64-bit machines back then??? Did Linux even exist back then??? From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 09/14/2010 11:37 AM Subject: Re: Unknown SQLCODE error [21284] Sent by: ids-bounces@iiug.org You are correct Fernando. I have vigorously slapped both of my hands. Versions: CSDK v 3.50.FC7 & 3.70.FC1B6 IDS 3.50.FC7 & 3.70.FC1B6 Ubuntu 9.04 Linux 64bit OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes <domusonline@gmail.com>wrote: > On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > > > > 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. > > > > --00163628363638f0bf04903af4b1 > > > > Shame on you! You should always post your versions! :) Just joking. > There are some internal references to it and a bug in CSDK 3.00. I would > need more time to check this, but it's related to using fetch array and > LVARCHAR. > If you have OPTOFC set, try without it. > > There was an APAR IC50423 related to this, but it looks relatively old > (2007). Some references found in a bug supposedly fixed on CSDK 3.0... > > Regards. > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001636283a7c528a7d04903b3d1d > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e889ec371e304903b9dca ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Art Kagel wrote: > > OK, 11.50.FC7 & 11.70.FC1B6, wise acre. ;-) I think you're going to regret this for a loooooong, loooooooooooong time. :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Hi, John John Miller iii schrieb: > Art: > > Being that you are running a release of Informix Server that is about 18 > years old, > we would like to ask that you upgrade soon. -:) have to jump in here! At least in EMEA for the poor guys running SCO or XENIX after Version 2.10.K was V4.10 - around autumn 1991 .... We never got any turbo 3 version in Europe ;) And also on the SUN LX boxes we never saw any INFORMIX version 3 or 6. dic_k > >> CSDK v 3.50.FC7 & 3.70.FC1B6 >> IDS 3.50.FC7 & 3.70.FC1B6 >> Ubuntu 9.04 Linux 64bit > > John F. Miller III > STSM, Embedability Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > >> [image removed] >> >> Re: Unknown SQLCODE error [21284] >> >> Art Kagel >> >> to: >> >> ids >> >> 09/14/2010 10:37 AM >> >> Sent by: >> >> ids-bounces@iiug.org >> >> Please respond to ids >> >> You are correct Fernando. I have vigorously slapped both of my hands. >> Versions: >> >> CSDK v 3.50.FC7 & 3.70.FC1B6 >> IDS 3.50.FC7 & 3.70.FC1B6 >> Ubuntu 9.04 Linux 64bit >> >> OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. >> >> 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes > <domusonline@gmail.com>wrote: >>> On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). >>>> >>>> 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. >>>> >>>> --00163628363638f0bf04903af4b1 >>>> >>> Shame on you! You should always post your versions! :) Just joking. >>> There are some internal references to it and a bug in CSDK 3.00. I > would >>> need more time to check this, but it's related to using fetch array and > >>> LVARCHAR. >>> If you have OPTOFC set, try without it. >>> >>> There was an APAR IC50423 related to this, but it looks relatively old >>> (2007). Some references found in a bug supposedly fixed on CSDK 3.0... >>> >>> Regards. >>> -- >>> Fernando Nunes >>> Portugal >>> >>> http://informix-technology.blogspot.com >>> My email works... but I don't check it frequently... >>> >>> --001636283a7c528a7d04903b3d1d >>> >>> >>> >>> > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> >> --0016361e889ec371e304903b9dca >> >> >> > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe
or some Informix SE wird DOS R4GL Version < 4.00 running on Netware 2.15 Joerg Volz --------------------------------------------- ________________________________ Von: ids-bounces@iiug.org im Auftrag von Richard Kofler Gesendet: Mi 15.09.2010 12:13 An: ids@iiug.org Betreff: Re: Unknown SQLCODE error [21292] Hi, John John Miller iii schrieb: > Art: > > Being that you are running a release of Informix Server that is about 18 > years old, > we would like to ask that you upgrade soon. -:) have to jump in here! At least in EMEA for the poor guys running SCO or XENIX after Version 2.10.K was V4.10 - around autumn 1991 .... We never got any turbo 3 version in Europe ;) And also on the SUN LX boxes we never saw any INFORMIX version 3 or 6. dic_k > >> CSDK v 3.50.FC7 & 3.70.FC1B6 >> IDS 3.50.FC7 & 3.70.FC1B6 >> Ubuntu 9.04 Linux 64bit > > John F. Miller III > STSM, Embedability Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > >> [image removed] >> >> Re: Unknown SQLCODE error [21284] >> >> Art Kagel >> >> to: >> >> ids >> >> 09/14/2010 10:37 AM >> >> Sent by: >> >> ids-bounces@iiug.org >> >> Please respond to ids >> >> You are correct Fernando. I have vigorously slapped both of my hands. >> Versions: >> >> CSDK v 3.50.FC7 & 3.70.FC1B6 >> IDS 3.50.FC7 & 3.70.FC1B6 >> Ubuntu 9.04 Linux 64bit >> >> OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. >> >> 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes > <domusonline@gmail.com>wrote: >>> On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). >>>> >>>> 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. >>>> >>>> --00163628363638f0bf04903af4b1 >>>> >>> Shame on you! You should always post your versions! :) Just joking. >>> There are some internal references to it and a bug in CSDK 3.00. I > would >>> need more time to check this, but it's related to using fetch array and > >>> LVARCHAR. >>> If you have OPTOFC set, try without it. >>> >>> There was an APAR IC50423 related to this, but it looks relatively old >>> (2007). Some references found in a bug supposedly fixed on CSDK 3.0... >>> >>> Regards. >>> -- >>> Fernando Nunes >>> Portugal >>> >>> http://informix-technology.blogspot.com >>> My email works... but I don't check it frequently... >>> >>> --001636283a7c528a7d04903b3d1d >>> >>> >>> >>> > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> >> --0016361e889ec371e304903b9dca >> >> >> > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de
Just a little bit of history. There was a very limited release of version 3 engine and its code name was "pop". The theme of the code names came from a cereal commercial. Anyone want to guess which cereal?? I only worked with a few customers who had this version and I can not say if it made its way to Europe or not. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/15/2010 03:13:07 AM: > [image removed] > > Re: Unknown SQLCODE error [21292] > > Richard Kofler > > to: > > ids > > 09/15/2010 03:14 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi, John > > John Miller iii schrieb: > > Art: > > > > Being that you are running a release of Informix Server that is about 18 > > years old, > > we would like to ask that you upgrade soon. -:) > > have to jump in here! > At least in EMEA for the poor guys running SCO or XENIX after Version 2.10.K > was V4.10 - around autumn 1991 .... > We never got any turbo 3 version in Europe ;) > And also on the SUN LX boxes we never saw any INFORMIX version 3 or 6. > > dic_k > > > > >> CSDK v 3.50.FC7 & 3.70.FC1B6 > >> IDS 3.50.FC7 & 3.70.FC1B6 > >> Ubuntu 9.04 Linux 64bit > > > > John F. Miller III > > STSM, Embedability Architect > > miller3@us.ibm.com > > 503-578-5645 > > IBM Informix Dynamic Server (IDS) > > > > ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > > > >> [image removed] > >> > >> Re: Unknown SQLCODE error [21284] > >> > >> Art Kagel > >> > >> to: > >> > >> ids > >> > >> 09/14/2010 10:37 AM > >> > >> Sent by: > >> > >> ids-bounces@iiug.org > >> > >> Please respond to ids > >> > >> You are correct Fernando. I have vigorously slapped both of my hands. > >> Versions: > >> > >> CSDK v 3.50.FC7 & 3.70.FC1B6 > >> IDS 3.50.FC7 & 3.70.FC1B6 > >> Ubuntu 9.04 Linux 64bit > >> > >> OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. > >> > >> 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes > > <domusonline@gmail.com>wrote: > >>> On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > >>>> > >>>> 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. > >>>> > >>>> --00163628363638f0bf04903af4b1 > >>>> > >>> Shame on you! You should always post your versions! :) Just joking. > >>> There are some internal references to it and a bug in CSDK 3.00. I > > would > >>> need more time to check this, but it's related to using fetch array and > > > >>> LVARCHAR. > >>> If you have OPTOFC set, try without it. > >>> > >>> There was an APAR IC50423 related to this, but it looks relatively old > >>> (2007). Some references found in a bug supposedly fixed on CSDK 3.0... > >>> > >>> Regards. > >>> -- > >>> Fernando Nunes > >>> Portugal > >>> > >>> http://informix-technology.blogspot.com > >>> My email works... but I don't check it frequently... > >>> > >>> --001636283a7c528a7d04903b3d1d > >>> > >>> > >>> > >>> > > > > > ******************************************************************************* > > > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > >>> > >>> > >> --0016361e889ec371e304903b9dca > >> > >> > >> > > > > > ******************************************************************************* > > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Richard Kofler > SOLID STATE EDV > Dienstleistungen GmbH > Vienna/Austria/Europe > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Surely not "Rice Krispies" . . John Carlson x17085 For Informix / MySQL emergencies: Go to http://cphpis00.homedepot.com/cgi-bin/beep0.cgi Select "Informix_DBAs" in the Show/Beep on Call for Group drop down box. Please do not high priority email lists. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Wednesday, September 15, 2010 11:56 AM To: ids@iiug.org Subject: Re: Unknown SQLCODE error [21300] Just a little bit of history. There was a very limited release of version 3 engine and its code name was "pop". The theme of the code names came from a cereal commercial. Anyone want to guess which cereal?? I only worked with a few customers who had this version and I can not say if it made its way to Europe or not. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/15/2010 03:13:07 AM: > [image removed] > > Re: Unknown SQLCODE error [21292] > > Richard Kofler > > to: > > ids > > 09/15/2010 03:14 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi, John > > John Miller iii schrieb: > > Art: > > > > Being that you are running a release of Informix Server that is about 18 > > years old, > > we would like to ask that you upgrade soon. -:) > > have to jump in here! > At least in EMEA for the poor guys running SCO or XENIX after Version 2.10.K > was V4.10 - around autumn 1991 .... > We never got any turbo 3 version in Europe ;) > And also on the SUN LX boxes we never saw any INFORMIX version 3 or 6. > > dic_k > > > > >> CSDK v 3.50.FC7 & 3.70.FC1B6 > >> IDS 3.50.FC7 & 3.70.FC1B6 > >> Ubuntu 9.04 Linux 64bit > > > > John F. Miller III > > STSM, Embedability Architect > > miller3@us.ibm.com > > 503-578-5645 > > IBM Informix Dynamic Server (IDS) > > > > ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > > > >> [image removed] > >> > >> Re: Unknown SQLCODE error [21284] > >> > >> Art Kagel > >> > >> to: > >> > >> ids > >> > >> 09/14/2010 10:37 AM > >> > >> Sent by: > >> > >> ids-bounces@iiug.org > >> > >> Please respond to ids > >> > >> You are correct Fernando. I have vigorously slapped both of my hands. > >> Versions: > >> > >> CSDK v 3.50.FC7 & 3.70.FC1B6 > >> IDS 3.50.FC7 & 3.70.FC1B6 > >> Ubuntu 9.04 Linux 64bit > >> > >> OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. > >> > >> 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes > > <domusonline@gmail.com>wrote: > >>> On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > >>>> > >>>> 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. > >>>> > >>>> --00163628363638f0bf04903af4b1 > >>>> > >>> Shame on you! You should always post your versions! :) Just joking. > >>> There are some internal references to it and a bug in CSDK 3.00. I > > would > >>> need more time to check this, but it's related to using fetch array and > > > >>> LVARCHAR. > >>> If you have OPTOFC set, try without it. > >>> > >>> There was an APAR IC50423 related to this, but it looks relatively old > >>> (2007). Some references found in a bug supposedly fixed on CSDK 3.0... > >>> > >>> Regards. > >>> -- > >>> Fernando Nunes > >>> Portugal > >>> > >>> http://informix-technology.blogspot.com > >>> My email works... but I don't check it frequently... > >>> > >>> --001636283a7c528a7d04903b3d1d > >>> > >>> > >>> > >>> > > > > > ******************************************************************************* > > > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > >>> > >>> > >> --0016361e889ec371e304903b9dca > >> > >> > >> > > > > > ******************************************************************************* > > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Richard Kofler > SOLID STATE EDV > Dienstleistungen GmbH > Vienna/Austria/Europe > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all
Snap, Crackle and Pop, like those project names?? John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/16/2010 07:46:21 AM: > From: > > "Carlson, John" <John_Carlson@HomeDepot.com> > > To: > > ids@iiug.org > > Date: > > 09/16/2010 07:51 AM > > Subject: > > RE: Unknown SQLCODE error [21315] > > Sent by: > > ids-bounces@iiug.org > > Surely not "Rice Krispies" . . > > John Carlson > x17085 > > For Informix / MySQL emergencies: > Go to http://cphpis00.homedepot.com/cgi-bin/beep0.cgi > Select "Informix_DBAs" in the Show/Beep on Call for Group drop down box. > Please do not high priority email lists. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John > Miller iii > Sent: Wednesday, September 15, 2010 11:56 AM > To: ids@iiug.org > Subject: Re: Unknown SQLCODE error [21300] > > Just a little bit of history. > > There was a very limited release of version 3 engine and its code > name was "pop". The theme of the code names came from a cereal > commercial. Anyone want to guess which cereal?? > > I only worked with a few customers who had this > version and I can not say if it made its way to Europe or not. > > John F. Miller III > STSM, Embedability Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 09/15/2010 03:13:07 AM: > > > [image removed] > > > > Re: Unknown SQLCODE error [21292] > > > > Richard Kofler > > > > to: > > > > ids > > > > 09/15/2010 03:14 AM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids > > > > Hi, John > > > > John Miller iii schrieb: > > > Art: > > > > > > Being that you are running a release of Informix Server that is about > 18 > > > years old, > > > we would like to ask that you upgrade soon. -:) > > > > have to jump in here! > > At least in EMEA for the poor guys running SCO or XENIX after Version > 2.10.K > > was V4.10 - around autumn 1991 .... > > We never got any turbo 3 version in Europe ;) > > And also on the SUN LX boxes we never saw any INFORMIX version 3 or 6. > > > > dic_k > > > > > > > >> CSDK v 3.50.FC7 & 3.70.FC1B6 > > >> IDS 3.50.FC7 & 3.70.FC1B6 > > >> Ubuntu 9.04 Linux 64bit > > > > > > John F. Miller III > > > STSM, Embedability Architect > > > miller3@us.ibm.com > > > 503-578-5645 > > > IBM Informix Dynamic Server (IDS) > > > > > > ids-bounces@iiug.org wrote on 09/14/2010 10:34:20 AM: > > > > > >> [image removed] > > >> > > >> Re: Unknown SQLCODE error [21284] > > >> > > >> Art Kagel > > >> > > >> to: > > >> > > >> ids > > >> > > >> 09/14/2010 10:37 AM > > >> > > >> Sent by: > > >> > > >> ids-bounces@iiug.org > > >> > > >> Please respond to ids > > >> > > >> You are correct Fernando. I have vigorously slapped both of my hands. > > >> Versions: > > >> > > >> CSDK v 3.50.FC7 & 3.70.FC1B6 > > >> IDS 3.50.FC7 & 3.70.FC1B6 > > >> Ubuntu 9.04 Linux 64bit > > >> > > >> OK, LVARCHAR & Array Fetch, that makes sense. No OPTOFC set. > > >> > > >> 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 Tue, Sep 14, 2010 at 1:06 PM, Fernando Nunes > > > <domusonline@gmail.com>wrote: > > >>> On Tue, Sep 14, 2010 at 5:46 PM, Art Kagel <art.kagel@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). > > >>>> > > >>>> 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. > > >>>> > > >>>> --00163628363638f0bf04903af4b1 > > >>>> > > >>> Shame on you! You should always post your versions! :) Just joking. > > >>> There are some internal references to it and a bug in CSDK 3.00. I > > > would > > >>> need more time to check this, but it's related to using fetch array > and > > > > > >>> LVARCHAR. > > >>> If you have OPTOFC set, try without it. > > >>> > > >>> There was an APAR IC50423 related to this, but it looks relatively > old > > >>> (2007). Some references found in a bug supposedly fixed on CSDK > 3.0... > > >>> > > >>> Regards. > > >>> -- > > >>> Fernando Nunes > > >>> Portugal > > >>> > > >>> http://informix-technology.blogspot.com > > >>> My email works... but I don't check it frequently... > > >>> > > >>> --001636283a7c528a7d04903b3d1d > > >>> > > >>> > > >>> > > >>> > > > > > > > > > > > ******************************************************************************* > > > > > > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > > >>> > > >>> > > >> --0016361e889ec371e304903b9dca > > >> > > >> > > >> > > > > > > > > > > > ******************************************************************************* > > > > > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > >> > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > >