... UPDATE FOO SET X = 1 WHERE Y = 2; DECLARE INTEGER UPDATED = VARIABLES.ROWCOUNT; ...
VARIABLES.ROWCOUNT integer variable will contain the numbers of rows affected by the last INSERT, UPDATE, or DELETE command statement executed.
Inserts that are processed by dynamic SQL with an
into clause will also update the
Non-update command statements (
WITHOUT RETURN) will reset the
ROWCOUNT to 0.
To ensure you are getting the appropriate