Re: sqlca.sqlcode in stored procedure

Posted in 1997

MarkDenham@aol.com — 18 Jul 1997 19:58:07 -0400 — source: Informix-list mailing list archive (1991-1998)

You cannot as such. Use an exception block around the code that you need to monitor: DEFINE sqlerr INTEGER; DEFINE isamerr INTEGER; ON EXCEPTION SET sqlerr, isamerr -- your code here END EXCEPTION; When you get an error, the 2 variables get set. If you need to pass the error out of you program, use the RAISE EXCEPTION statement. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)