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
Vertica Tip: Display the Current Statement Number Within the Current Transaction
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Vertica Tip: Display the Current Statement Number Within the Current Transaction
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.