Re: ESQL/C Error check in Informix 7 opinions?

Posted in 1997

Art S. Kagel — Wed, 17 Dec 1997 15:17:22 -0500 — source: Informix-list mailing list archive (1991-1998)

Mark Palumbo wrote: > Do you think it is "ok" for us to continue our ESQL/C development > using the SQLCODE to check for Informix errors as opposed to the > new GET DIAGNOSTICS and SQLSTATE method? > Will SQLCODE support go away in future versions of Informix? > The Informix-ESQL/C "Programmer's Manual Version 7.2" recommends > the use of the new method, however, gives little support as to why. > X/Open and ANSI compiliance are not important to us (gasp) and we > typically do not care if multiple errors occur. (The stated > benefits of the new error checking method) The new method is ANSI and therefore portable. Being portable and generic, despite the ability for a vendor to extent the diagnostics provided, it is not as powerful as the sqlca structure. The sqlca structure is unlikely to go away in the near future. Art S. Kagel