LOG file for Stored Procedure in Teradata.

Database
Enthusiast

LOG file for Stored Procedure in Teradata.

Hi ,

I am using a Stored procedure in teradata , in which multiple updates are written. I want to generate log file for Stored Procedure. so that i can come to know how many rows are getting updated by each update statement.

is there any why to implement this. 

3 REPLIES
Teradata Employee

Re: LOG file for Stored Procedure in Teradata.

Define your log as a table and do SQL INSERTs of whatever data you want into your log table.

Enthusiast

Re: LOG file for Stored Procedure in Teradata.

how to insert how many rows updated by an Update statement ?  is there any query that tells how many rows upadated by a perticular update statement? 

Enthusiast

Re: LOG file for Stored Procedure in Teradata.

Hi Lata,

There is a status variable ACTIVITY_COUNT that stores the number of rows impacted by the previous DML statement in the procedure.

Regards,

Steve.