Re: Severity Levels for Error Codes

Although we don't use ESQL/C the issues are about the same whatever the language is. We do this relatively simply by handling spesific errors (locking related and others) doing retries or whatever else is appropriate. All other errors are logged and reported to the dba. The user of the application is informed that he should not use it for any purpose until he has talked to the dba. On interactive aplications we tell the user this very explisitly and leaves him in a state where he can not do anything more except terminate the application. georg@cyberdude.com (Georg Winkens) wrote: :Has anybody experience in categorising Informix error codes into a kind :of severity levels? We are just looking into a general error handling :concept using Informix ESQL/C. After an error returned by the engine we :would like to trigger an adequate action (ignore, log error, retry, :inform Dba, ...). The categorisation provided by SQLSTATE classes is not :sufficient because it seems that all Informix specific errors (Class IX) :are not divided into subclasses. Is there perhaps any kind of :categorisation provided by using SQLCODE? :Any suggestion, idea, comment, ... ? :Thanks, : Georg : georg@cyberdude.com : Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org