Path: utzoo!news-server.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!ukc!axion!vision!chris
From: chris@vision.uucp (Chris Davies)
Newsgroups: comp.databases
Subject: Informix messages in ESQL/C
Message-ID: <1991Mar13.171305.16997@vision.uucp>
Date: 13 Mar 91 17:13:05 GMT
Reply-To: chris@vision.UUCP (Chris Davies)
Organization: VisionWare Ltd., Leeds, UK
Lines: 34

WRT Informix databases, at least version 2, probably OnLine/version 4 too...

I have an application written with Informix's ESQL/C embedded SQL in C (not
the 4GL product).  When an error occurs, the error number can be found from
the sqlca structure (in sqlca.sqlcode).  What I would like to do is to be
able to obtain the error text associated with that error number.

Alas, there doesn't seem to be any way of doing this, and it does seem rather
antiquated to tell the user "look the error number up in the book...".

I can see the error messages (they're in the .iem files in $INFORMIXDIR/msg)
but I cannot work out the file structure  :-)

I don't want to re-enter the messages into my program (or a file of my own
doing), since Informix Software Inc could
	(a) complain about breaches of copyright on the messages
	(b) change the messages or create new ones

and either of these situations would be problematical(!).

Can anyone help shed some light on how I would go about getting these error
messages?  A portable solution (ie works on any platform with an Informix
database on it) would be preferable.

Informix UK say "it can't be done", but then UK bits of other US companies
always say that when something's not in the manuals...  :-(

Ta,
    Chris
-- 
VISIONWARE LTD         | UK: chris@vision.uucp    JANET: chris%vision.uucp@ukc
57 Cardigan Lane       | US: chris@vware.mn.org   BANGNET: ...!ukc!vision!chris
LEEDS LS4 2LE, England | VOICE:  +44 532 788858   FAX:  +44 532 304676
-------------- "VisionWare:   The home of DOS/UNIX/X integration" -------------