Re: Database Status in stored procedure

Posted in 1997

"Billy Wheeler" — 11 Apr 1997 01:38:04 -0400 — source: Informix-list mailing list archive (1991-1998)

On 10 Apr 97 at 13:19, jfk@sigsys.com wrote: > I am wondering how I can get the database SQLSTATUS and ROW_COUNT when > I execute an insert/update from a stored procedure. I noticed there is > a status variable in 4GL, but it does me no good for this purpose. RTFM. You're looking for the SQLCA record. Less specifically, you're looking for (I think) SQLCA.SQLERRD[3]. HTH. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Johannesburg "Wow, that's a big word for an eight-year old!!"