Re: "Network user authorization table"?

Jay Andrew Allen <jayallen@auragen.com> wrote in article <622oam$hju@cssun.mathcs.emory.edu>... > 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 > > 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? If you want to supply your own text for the error message, you need to use a specific exception number. I don't remeber the exact number, but -900 is not it. As you can see from the text returned by Informix, -900 has a specific meaning. Check the "Guide to SQL: Syntax". HTH -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com