All Forums Database
Anand.Louis 2 posts Joined 09/11
03 Nov 2011
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

Shiro 7 posts Joined 10/15
08 Jan 2016

Hi Anand,
I am facing the same challenge. 
Can anybody help?
 
 
 
 
 

dins2k2 51 posts Joined 05/13
11 Jan 2016

Hi,

This thread will help you.
 
https://forums.teradata.com/forum/database/how-to-get-the-activity-count-in-a-stored-procedure
 
Thanks,
Dinesh

Shiro 7 posts Joined 10/15
11 Jan 2016

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. 

dins2k2 51 posts Joined 05/13
02 Feb 2016

Shiro,
 
Deiter has already answerd your question.
https://forums.teradata.com/forum/database/activity-count-of-dbc-sysexecsql
 
Anyway thanks.
 
Thanks,
Dinesh

You must sign in to leave a comment.