RE: Return codes for SPL

> I believe that informix is on the right track with Stored > Procedures and Triggers (5.01) as far as I understand them. > I can see much benefit in their > concept and use especially when cascading transactions. > I also believe that they would be a lot more powerful if one could > somehow > use and check return codes. This could easily be done within ESQL\\c, > but that kind of defeats their intended purpose of straying from and > maintaining outside code. If I've understood your question correctly, you should be able to accomplish what you want to do by way of the RAISE EXCEPTION facility. A custom-raised exception number is received by the calling routine (ESQL, or even 4GL if you've worked out how to call procedures from it...) as though it were an SQL error code. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------- 44 272 742815