Re: Retrieving a error code from a SQL statement in SPL (Code SQLCA)

Posted in 1998

Octav Chiriac — Wed, 18 Nov 1998 10:01:21 +0200 (EET) — source: Informix-list mailing list archive (1991-1998)

If you need just the error code you could try: DEFINE errcode, isamerr INT; DEFINE errmsg CHAR(78); ON EXCEPTION SET errcode, isamerr, errmsg -- Place here your exception handling code END EXCEPTION ; -- Place here you SQL statements Hope it helps, Octav bruno statuto wrote: > Hello, > I'm am currently having problems retriving a error code in a >stored procedure. > Does anyone know how to retrieve a error code after an SQL >statement implemented in SPL ? > Can use sqlca , dbinfo or other ? > Thanks. > > Bruno. > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com