Multiple statement execution

[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

[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).