Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica Transactions

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 Administrator

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

  • 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.