Re: Q:How to use RAISE EXCEPTION in SPL?

> If you use error no, I think it's -769 or something close by, the error > text is simply '%s', so it takes whatever message you supplied. The > version 6.00 manuals tell you all about using this. The number is > specifically set aside for custom SPL errors. -745 is the number > The disadvantage is that your front-end can't use the number alone to > distinguish between one application-raised error and another; and a call > to err_get() would be pretty useless. > > One technique I've tried is to use the error numbers 5000 to 5999. These > were reserved for the ancient File-It! product that Informix sold way > back in the early 80s. Use mkmessage to define your own error text for > akent@cix.compulink.co.uk (Andy Kent) We use an error code as the text string that we raise with 745. Then our application programs recognise the 745 error and use the error code in the text string to look up the error message from a error file. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Company: DHL Systems Inc, Burlingame, CA, USA ----------------------------------------------------------------------