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

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

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

Post by JimKnicely » Wed Sep 26, 2018 4:06 pm

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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”