I am using Data Studio 3.1 Full Client with DB2 9.7 Express. I am unable to add more than 1 stored procedures with the same name. DB2 supports this scenario, provided the signature of procedures should be different and a specific name should be specified in the procedure declaration. In the New Stored Procedure dialog, when I specify the name of an existing procedure in the project, then the Finish button is not enabled to proceed further. But this was quite possible with the earlier versions of Data Studio which I had used. Please review the screen capture of the New Stored Proicedure dialog box attached
Please share your experiences and help to resolve the problem
This topic has been locked.
1 reply Latest Post - 2013-01-24T23:06:25Z by SystemAdmin
Pinned topic Need help - Adding stored procedures with same name
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-24T23:06:25Z at 2013-01-24T23:06:25Z by SystemAdmin
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: Need help - Adding stored procedures with same name2013-01-24T23:06:25Z in response to SystemAdminHi there,
Yes it is a known issue. The creation wizard prevents user from creating a stored procedure in the same name. The quick workaround is:
Goal: to create 2 stored procedures with same name
step 1: create the first stored procedure, for example, name it "PROCEDURE1".
step 2: create the 2nd stored procedure, name it "PROCEDURE2" for the moment.
step 3: In the editor, change PROCEDURE2 to PROCEDURE1. Save.
You will see two stored procedures of PROCEDURE1 in your project tree.
Hope it helps. Thanks!