Toad World® Forums

Is there a way to run a single piece of SQL from the editor (run selected)

In Quest Central there was a execute, execute selected statement(s), and a step execute from cursor.

Is there a way to do this in Toad for DB2 4.7 Editor?

Toad DB2's SQL Editor is a bit different than Quest Central for DB2, however you will find you can do most things in Toad DB2's SQl Editor as well.

There are a set of buttons that can be added to the SQL Editor toolbar.

Execute SQL will run the entire script OR if you select (highlight) some SQL it will only run the selected SQL.

Execute Current Statement will run only the statement your cursor is on.

Execute from Cursor will run all statements beginning on the statement where your cursor is on.

See the attached for a screenshot showing these buttons.