Re: NON LOGGING ? LOGGING ? MODE ANSI ?

Posted in 1995

Puru Balakrishnan — 1 Sep 1995 02:08:44 GMT — source: Informix-list mailing list archive (1991-1998)

In article <DE76H9.9Au@attwat.Waterloo.ATTGIS.COM>, Prateek Srivastava <Prateek.Srivastava@Waterloo.ATTGIS.Com> says: > hi how can i find from within an esql/c application if the database is logging/nonlogging/ansi. i want to use this information to figure out from within the application if BEGIN WORK, COMMIT WORK, etc need to be executed. an email will be most appreciated. prateek >prateek.srivastava@waterloo.attgis.com Check the sqlwarn structure in sqlca. If sqlwarn1 is set to W , then the db uses transaction log and if sqlwarn2 is set to W the database is ansi-complaint. (Refer to ESQL/C Programmer's Manual) HTH. Puru Balakrishnan