Special Variables

You are looking at an older version of the documentation. The latest version is found here.

The VARIABLES.ROWCOUNT integer variable contains the numbers of rows affected by the last INSERT/UPDATE/DELETE command statement executed. Inserts that are processed by dynamic SQL with an into clause will also update the ROWCOUNT .

Example

BEGIN
...
UPDATE FOO SET X = 1 WHERE Y = 2;
DECLARE INTEGER UPDATED = VARIABLES.ROWCOUNT;
...
END