Re: SPL: How to react to NOTFOUND

Posted in 1997

vfraenkle@aol.com — 29 Jan 1997 05:06:53 GMT — source: Informix-list mailing list archive (1991-1998)

Im Artikel <32EBEDCD.5C4A@ana.med.uni-muenchen.de>, Richard Spitz <spitz@ana.med.uni-muenchen.de> schreibt: >I tried catching the NOTFOUND with ON EXCEPTION IN (100), but it seems >that NOTFOUND doesn't raise an exception at all. Is that correct? How >can >I find out in my procedure whether the SELECT returned a NOTFOUND? > >Regards, Richard I am not shure, but try it with ON EXCEPTION IN (-100). Ciao, Volker

Related threads

Fragmentation Fundamental Question
LVARCHAR data type
ontape -l show 100% full logs but ontape -a doesn't flush them
Re: SQL convert number into the date
Re: Slow dbexport