Testing locks in Aubit4gl

"James B. Byrne via Aubit4gl-discuss" <[email protected]> Mon, 12 Jul 2021 16:19:04 -0400
Newsgroups gmane.comp.lang.4gl.aubit.general
Message-ID <[email protected]>
I am working through the exercises in "Informix4GL by Example".  I am at
exercises 22 and 23.  These are specific to the Informix database system and
check for error codes: First to determine the database features; and second to
determine if an attempted lock is successful or not.

These error codes
(-107,-113,-134,-143,-144,-154,329,-349,354-377,-512,-513,-527,-827) are not
documented in PostgreSQL so I infer that they apply only to Informix.

My question is:  Are there equivalent error codes for determining whether or
not a table or row lock as succeeded or failed and why:  If so then where are
they documented?

PostgreSQL notes that SQLCODE is deprecated in favour of SQLSTATE.  I gather
that the SQLSTATE structure is not implemented in Aubit4GL. PostgreSQL list of
valid error codes is very much limited.

SO, if one cannot get the reason for a lock failing through examining an error
code then how does one do so in Aubit4GL?

Any help is appreciated.

-- 
***          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