I have a suggestion for TOAD and I think its pretty easy to make happen or I hope.
Whenever I create stored procedures I always start my parameters with am ‘@’ sign. When you right click and execute a proc within TOAD it will be default put an ‘@’ in front of parameters.
My issue is I already have that ‘@’ sign so now I have two of them.
Here is an example:
Is there any way we can have a check box to enable auto putting an ‘@’ sign in variables or have the software look for them before doing the call?
It just sucks my proc always fail when I use the gui to execute the proc. Here is a sample DDL:
CREATE PROCEDURE sysproc.ParmExample(in @Parm1 varchar(500))
PARAMETER CCSID EBCDIC
DYNAMIC RESULT SETS 1
CALLED ON NULL INPUT
DECLARE RESULT_CSR CURSOR WITH RETURN FOR
Select @Parm1 as Parm1
from SYSIBM.SYSDUMMY1 SY;
GRANT EXECUTE ON PROCEDURE sysproc.ParmExample TO PUBLIC#
I just one more suggestion. This is not causing an error, but it shows a red line for syntax error.
I have changed my statement delimiter to a ‘#’ sign, but when you right click and execute a proc it is using a ‘;’ sign. Is there anyway to make TOAD so it will use the delimiter you set in the settings of the application?
here is a screen shot:
Thanks for much for your hard work on this product! I love all the new features and glad to see active dev on the application.
I am using Toad for DB2 Beta 188.8.131.52 (64 bit) for z/OS.