Re: status from SPL

Posted in 1995

"Andy Kent" — Wed, 18 Jan 1995 09:54:43 GMT — source: Informix-list mailing list archive (1991-1998)

> Hi Guys: > We are trying to get the number of records processed from > a stored procedure. In esql/c we used to get the value by grabbing > sqlca.sqlerrd[2]. How do we do in SPL(Stored Procedure Language)?? > > Thanks in advance. > > > Suresh & Kishore The 6.00-on engines have an SQL function DBINFO() which allows you to get at certain sqlca stuff. If you're not yet on 6.00 or later, you have to count the rows tediously yourself. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------