Vertica Transactions

Slaagh

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!

[Deleted User]

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

Slaagh

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!