how to get number of rows affected by an update in INGRES

Question

How can you get the rows affected by an SQL UPDATE statement in INGRES?

eg: SELECT COUNT (*) FROM ( UPDATE gare SET code_gare = 'AB-BV' WHERE code_gare = 'AB' )

RESULT count = 2 (something like this)

Do you intend to use the number of updated rows from another language? If so, which one? — Adrian, Aug 19 '14 at 13:26

score 1 · Answer 1 · answered Jul 10 '13 at 10:59

Ingres can distinguish rows actually updated from rows that satisfied the WHERE clause. Depending on the system configuration one or the other will be reported, so you need to know the local setting. Applications can override the system configuration by executing the SET UPDATE_ROWCOUNT CHANGED | QUALIFIED statement.

The row count is returned in the SQLCA if you are using embedded SQL in a host 3GL, or you can obtain it using the embedded INQUIRE_SQL ( :n=rowcount ) statement. In other languages/APIs the row count will be returned in the locally appropriate way. (For more detail please indicate your language.)

how to get number of rows affected by an update in INGRES

1 Answers1