Skip to main content

Vertica Transactions

  • April 4, 2017
  • 2 replies
  • 17 views

Slaagh
Forum|alt.badge.img+1
  • Participating Frequently

Hello,

I am trying to get some information about Vertica Transactions. I ran a few Google searches and the only syntax that I found was using the ADO.NET object to create them.

Is there a way to write Vertica Transaction similar to the way it is done in SQL and/or Oracle? Or do I have to use the ADO.NET object?

Something like this...

CREATE TRANSACTION test
BEGIN TRAN
SELECT * FROM table
END TRAN
COMMIT;

Thank you!

2 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • April 5, 2017

Can you check for START TRANSACTION and END in vertica documentation . I think it may serve your purpose .


Slaagh
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • April 5, 2017

I saw that, but it is using the ADO.NET driver. I did not see any documentation for T-SQL transaction syntax.

Thank you for your response!