Vertica Transactions

SlaaghSlaagh Registered User

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!

Comments

  • skamatskamat Employee, Registered User, VerticaExpert

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

  • SlaaghSlaagh Registered User

    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!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file