Toad World® Forums

How to execute same request on multiple database

Toad for IBM DB2
#1

Hi,

I would like to launch a request accross 60 databases.
How could I do this with toad for db2 ?

Best regards,
Bruno

#2

Use “Group Execute” feature:
Editor->Windows->Group Execute

#3

Hi,

I don’t have any windows tab in Editor menu.
I use the version 5.0.4.731 of toad for db2.
Do I need to du an update ?

Best regards,
Bruno

#4

Look in attach.

  1. Open Editor
  2. In main menu choose (should be checked): Editor->Windows->Group Execute
    GrEx2.png
#5

Look in attach.

  1. Open Editor
  2. In main menu choose (should be checked): Editor->Windows->Group Execute
    GrEx.png
    GrEx.png747×555 58.4 KB
#6

Hi vlas.titov,

thank you for your help,
I don’t find any windows tab, in the editor menu.
But I 've found the solution.
I must open an editor and do right-click, check “Show Group Execute”,
and select the “enable” checkbox.
After that I can filter by folder and by connection name.

Do you think, it’s depend of the version ?
My version is 5.0.4.731.

Best regards,
Bruno

#7

May be yes,- I don’t have 5.0.4 installed already.
5.1 and 5.2 (internal) only.