Oninit cdi / Archive
Talk to an expert →

No.of rows affected

Posted in 2000

Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL

Usha M Rao — — source: Informix-list mailing list archive (1991-1998)

In informix SPL or 4gl ,how will I get the no. of rows affected by an Update or Delete statement? Usha

↪ replying to Usha M Rao
Padma — — source: Informix-list mailing list archive (1991-1998)

In article <8aq8p9$caf$1@news.xmission.com>, "Usha M Rao" <usha_mr@trigent.com> wrote: > > In informix SPL or 4gl ,how will I get the no. of rows affected by an > Update or > Delete statement? > > Usha > > Hi, Check the SQLCA.SQLERRD record. (I am not sure about which element, though). Padma Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Usha M Rao
Chetan Anand — — source: Informix-list mailing list archive (1991-1998)

Usha: Try in 4gl SQLCA.SQLERRD[3] will return number of rows affected by SQL (UPDATE/DELETE), I think in SPL try DBINFO(..) Rgds Chetan Usha M Rao wrote: > In informix SPL or 4gl ,how will I get the no. of rows affected by an > Update or > Delete statement? > > Usha

Glossary