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

>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) >Your thoughts and opinions would be appreciated. Thank you. ------------------------------------------------------------------------ >Mark Palumbo >Roadway Express, Inc. >Field Systems Development >Akron, Ohio USA ------------------------------------------------------------------------ Mark Palumbo, hc33 @ x3332 Field Systems Development-- Hi Palumbo, I being using SQLSTATE & DIAGNOSTIC AREA in all my ESQLC programs. The advantages are that u get the exact error with the full length message. The errors are well subdivided into class & subclass. I think Its one of the good features in Informix. We have written a error trapping system which keeps track of all the errors occured & are sent to dba, programmers etc.. respectively. So we normally see the class & subclass to divide this. Plus it has user defined error. If u want to know how to use it, I am ready to help u. Regards, Praveen E-mail : praveen_mohanan@hotmail.com tel : 650.594.9899 x 217 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com