The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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!
0
Comments
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!