Page 1 of 1

Multiple statement execution

PostPosted: Fri May 20, 2016 11:27 am
by Ramprakash
Hi,

I'm using Dbeaver to connect one of my Vertica DB.
I have set of update statements (approx 100) to be executed through DBeaver.

For e.g.
Update <Table Name> set Emp Name='A' where Emp ID='123'
Update <Table Name> set Emp Name='B' where Emp ID='234'
....

Is there any option can that be executed in one shot?

Please suggest.

Regards,
Ram

Re: Multiple statement execution

PostPosted: Mon May 23, 2016 12:58 pm
by Serge
In scripts SQL statements have to be delimited by ";" symbol. This symbol in configurable in preferences.
Also you can execute individual statements (ctrl+enter) if they are delimited by ; or by blank lines.
At last you can select a query and execute it (ctrl+enter).