Re: status from SPL

In article <3f4kbd$4g3@oak.oakland.edu> syadat@mercury.eng.wayne.edu (Yadati Sainath) writes: >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)?? You could use a global variable and a Delete/Update/Insert-trigger on the processed table which increments this variable. I think its a little bit of overkill, but it should work. martin berns