Re: Testing locks in Aubit4gl

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