Page 1 of 1

Vertica Tip: Display the Current Statement Number Within the Current Transaction

Posted: Wed Sep 26, 2018 4:06 pm
by JimKnicely
A Transaction in Vertica is one or more operations that are executed as a unit of work. At the user level, transactions occur in the current session by a user or script running one or more SQL statements. A transaction has a unique Transaction ID and the “units of work” within a transaction are each identified by a sequential Statement number.

Find out how to display the current Transaction ID and Statement number here:
https://forum.vertica.com/discussion/23 ... ransaction