Re: Testing locks in Aubit4gl

It's literally the example I gave.


Informix : -217 Column column-name not found in any table in the query

Postgresql state 42703 : UNDEFINED COLUMN (
 https://www.postgresql.org/docs/8.2/errcodes-appendix.html)


Informix error messages come from finder (the Informix equivalent of
afinderr)

On Tue, 13 Jul 2021, 19:40 James B. Byrne via Aubit4gl-discuss, <
[email protected]> wrote:

>
>
> On Tue, July 13, 2021 13:18, James B. Byrne wrote:
> >
> >
> > On Tue, July 13, 2021 03:37, Mike Aubury wrote:
> >> You can use the etc/convertsql/INFORMIX-POSTGRES8.cnv to convert for any
> >> you need.
> >>
> >> eg.
> >>
> >> REMAP_ERROR 42703=-217
> >>
> >> Informix : -217    Column column-name not found in any table in the
> query
> >> Postgresql state 42703 :  UNDEFINED COLUMN  (
> >> https://www.postgresql.org/docs/8.2/errcodes-appendix.html)
> >>
> >>
> >
> >
> > The difficulty being that I cannot discover what -217 is supposed to
> mean to
> > begin with:
> >
> > $ afinderr -239
> > /opt/aubit4gl/etc/helpsql_POSTGRES8.hlp:
> > -239 duplicate key violates unique constraint
> >
> > $ afinderr -217
> > $
> >
>
> > I have looked for a list of error codes that Informix4GL is expecting in
> the
> > exercise and can find no such list.  References to finderr are the only
> > documentation I have located.  However, afinderr does not cover the error
> > codes that the exercise is looking for.
> >
>
> In my searches, and by adding the ISAM keyword to those, I discovered the
> following reference:
>
>
> https://querix.atlassian.net/wiki/spaces/QKB/pages/91750488/Error+codes+200+299
>
>
> This page contains the following entry:
>
> 217 Column column-name not found in any table in the query
> (or SLV is undefined).
>
> Which looks remarkably like the example given above.  Is this a
> coincidence or
> can I use the rest of these entries as if they were the Informix4GL error
> codes?
>
> --
> ***          e-Mail is NOT a SECURE channel          ***
>         Do NOT transmit sensitive data via e-Mail
>    Unencrypted messages have no legal claim to privacy
>  Do NOT open attachments nor follow links sent by e-Mail
>
> James B. Byrne                mailto:[email protected]
> Harte & Lyne Limited          http://www.harte-lyne.ca
> 9 Brockley Drive              vox: +1 905 561 1241
> Hamilton, Ontario             fax: +1 905 561 0757
> Canada  L8E 3C3
>
>
>
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss