Re: sqlca.sqlcode in stored procedure

Posted in 1999

Octav Chiriac — Fri, 3 Dec 1999 14:55:55 +0200 — source: Informix-list mailing list archive (1991-1998)

One way would be using "ON EXCEPTION SET errcode, isamerr, errmsg" to anallyze the error code. But in fact you can use just sqlca.sqlerrd1 and sqlca.sqlerrd2 with dbinfo function and you have no access to other sqlca structure members. Best Regards, Octav On Thu, Dec 02, 1999 at 08:45:57PM +0000, Igor wrote: > Hi All > > Is that possible to use sqlca.sqlcode in stored procedures? > > Regards > > > Igor -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com