Multiple statement execution

Note: please leave bug reports and feature requests on

Multiple statement execution

Postby Ramprakash » Fri May 20, 2016 11:27 am

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
Ramprakash
 
Posts: 1
Joined: Fri May 20, 2016 11:24 am

Re: Multiple statement execution

Postby Serge » Mon May 23, 2016 12:58 pm

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).
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 15 guests