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.
Within a Stored Procedure there's GET DIAGNOSTICS which includes TRANSACTION_ACTIVE, but this returns only 0/1.