Re: "Network user authorization table"?

On Wed, 15 Oct 1997, Jay Andrew Allen wrote: } I want to return custom error codes and text from stored procedures. The } docs say, simple - use } } RAISE EXCEPTION errNum, isamNum, errText } } Fine. So I place the statement in my code: } } RAISE EXCEPTION -900, 0, "Error!" } } when an error occurs. Informix returns: } } [Informix][OnLine Workgroup Server][auragen]SQL Error(-900): User not } found in network user authorization table That's morally equivalent to /etc/passwd, except it is o/s neutral. } The error number is right, but the text is mysterious. I've searched } through all available documentation for the "network user authorization } table," but can't find any mention of it. What is it, and what do I need } to do with it to make this error go away? Do not raise the exception! You told the system to return error -900, so it did. The approved error message is -746, which will simply print the errtext you provide in your RAISE EXCEPTION statement. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>