I want to use ACTIVITY_COUNT with DBC.SysExecSQL to get how many rows updated by the query executed in DBC.SysExecSQL.
Can anybody help me in this.
Simply use it:
SET myVAr = ACTIVITY_COUNT;
Btw, better use Standard compliant EXECUTE IMMEDIATE instead of SysExecSQL.
I did try above approach, but it seems to capture '0' always. My goal is to capture SP NAME, SQL and ACTIVITY_COUNT
I'm trying below.