Re: rows in select

Posted in 1996

Roger Hernandez — Tue, 12 Nov 1996 16:09:15 -0500 — source: Informix-list mailing list archive (1991-1998)

Tim Schaefer wrote: > > Is there any way to find out how many rows were selected > > in Informix v7 (online). > > > > Try > > select count(*) from ... Another way of doing it is (in a stored procedure): LET RowsSelected = DBINFO ('sqlca.sqlerrd2'); I believe you can also say: SELECT DBINFO ('sqlca.aqlerrd2') AS LastRowsSelected... Roger Hernandez