Subject Execute Statement & Row_Count in SP
Author constantijnw
Hi,

In a SP I have the following lines:

.
.
EXECUTE STATEMENT
'UPDATE ATAB SET ' || UPDATECLAUSE || ' WHERE ' || WHERECLAUSE;
ROWSAFFECTED = ROW_COUNT;
.
.

The DML statement works fine but ROW_COUNT returns 0 even when a row has
been updated.
Doesn't EXECUTE STATEMENT set ROW_COUNT?

Constantijn