Re: DB2 RAISE_ERROR equivalent in IDS

On 12/1/05, Manas Dadarkar <manasd@gmail.com> wrote: > I am trying to find out if the DB2 RAISE_ERROR function can be > implemented in IDS. The description of the function from the DB2 > documentation is as follows > > *The RAISE_ERROR function causes the statement that includes the function to > return an error with the specified SQLSTATE, SQLCODE -438, and > diagnostic-string.* The SQLSTATE is the bit that can't be done in IDS - there is an FR (feature request) to be able to set SQLSTATE from within RAISE EXCEPTION, but it needs some customer cases to get it any sort of priority. As others have said, you can easily create a procedure called RAISE_ERROR that does the rest. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ sending to informix-list