Number of begin transaction statement

Database
Teradata Employee

Number of begin transaction statement

Hi

 

Is there any way to get the number of begin transaction statement occurred in the current session. Actually we are moving code from SQL server to teradata. In SQL server, '@@TRANCOUNT' does the task. Do we have something like this in TeraData or some SQL query which can result the same output as @@TRANCOUNT.

 

 

Thanks

Akshat Rathi

1 REPLY
Senior Apprentice

Re: Number of begin transaction statement

Afaik, no.

 

Within a Stored Procedure there's GET DIAGNOSTICS which includes TRANSACTION_ACTIVE, but this returns only 0/1.