Re: determining transaction through 4gl

Posted in 1999

ackerbau@us.ibm.com — Fri, 8 Jan 1999 15:51:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Art Kagel wrote: >Immediately after the DATABASE or CONNECT statement that opens the >database check the values of sqlca.sqlwarn.sqlwarn1 and >sqlca.sqlwarn.sqlwarn2. If warn1='W' then the database has logging and >it is OK to commit or rollback. If warn2='W' then the database is an >ANSI mode database and BEGIN WORK is NOT permitted so the logic goes: [ 4GL code deleted ] Ha. You do it the hard way. ;) Back in the dark ages, we used a FourGen library that wrapped up a "begin work" statement within a "whenever error" handler. If the status came back as < 0, it set a global flag (not unlike your own) stating that logging was not allowed. Talk about your kludges . . . -mka Michael Ackerbauer SP System Test