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!
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
SELECT * FROM table
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!