I use both Toad for Oracle and Toad for Data Analysts.
In Toad for Oracle I use Shift+F9 to execute the code where my cursor is located (without having to highlight the entire SQL statement). However, using Toad for Data Analysts with a DB2 connection and with multiple SQL statements in the Editor, when I place cursor inside a statement and hit Shift+F9 it tries to execute globally and gives error ([DB2]SQL0199N "The use of the reserved word “SELECT” following “” is not valid…).
It seems that the behavior of shortcuts F5, F9 and Shift+F9 (and their corresponding menu bar buttons) is identical. The statement executes fine if I highlight it. and use any one of the shortcuts or buttons.
I have tried selecting the “Toad for Oracle keyboard scheme” (Tools/Options/Environment/Keyboard) without success. I tried creating a custom keyboard scheme using the Toad for Oracle keyboard scheme as a point of departure and then creating a new shortcut using Shift+F9 to “Execute the current SQL statement” but that didn’t succeed either. I tried the same process starting with the default keyboard scheme …no luck.
How do I get the Shift+F9 to execute the snippet at my cursor in Toad for Data Analysts without having to highlight the entire statement?