Hello. I use Toad for db2 version 7.4.1.12. In the options I can change the statement delimiter from the default ";" to for example the "@".
Question is, does a toad command (to use in the editor) exist to change it in the script file itself?
Reason: until now I used dbVisualizer to install stored procedures. I there needed the statement delimiter @ because otherwise the dbVisualizer tool recognised each statement of the procedure as a separate sql statement, which is not good.
In dbVisualizer itself, I used the following command:
@delimiter @; -- ending with ; because default delimiter still is the ;
Thank you for helping me, because I cannot find it anywhere, so it might not exist?