Activity Count from DBC.SYSEXECSQL in a Stored Procedure

Database
Teradata Employee

Activity Count from DBC.SYSEXECSQL in a Stored Procedure

Hi,

I am executing a SQL using DBC.SYSEXECSQL in a Store Procedure .

Can any one suggest me way to capture the activity count of sql executed 

Regards

Anand Louis

4 REPLIES
N/A

Re: Activity Count from DBC.SYSEXECSQL in a Stored Procedure

Hi Anand,

I am facing the same challenge. 

Can anybody help?

Re: Activity Count from DBC.SYSEXECSQL in a Stored Procedure

N/A

Re: Activity Count from DBC.SYSEXECSQL in a Stored Procedure

Hi Dinesh,

I want to use ACTIVITY_COUNT   with  DBC.SysExecSQL to get how many rows updated by query executed in  DBC.SysExecSQL.

The link you suggest, is for DML statements only in any Stored procedure. 

Re: Activity Count from DBC.SYSEXECSQL in a Stored Procedure

Shiro,

Deiter has already answerd your question.

https://forums.teradata.com/forum/database/activity-count-of-dbc-sysexecsql

Anyway thanks.

Thanks,

Dinesh