The IBM® Procedure Designer provides a framework for you to rapidly develop IBM database procedures that use SQL or SPL.
Important: If you use Visual Studio 2008, do not create stored procedures with names that are longer than 39 characters. Stored procedures with names that are longer than 39 characters can cause errors when you use the Visual Studio 2008 debugger and other components.
To open the IBM Procedure Designer:
- If you want to create a procedure, in the Server Explorer, right-click Procedures under your data connection, and then select Add New SQL Procedure with Designer on the shortcut menu.
- If you want to create a procedure that is based on an existing procedure, in the Server Explorer under your data connection, right-click the procedure that you want to use, and then select Clone Procedure Definition on the shortcut menu.
- If you want to modify a procedure, in the Server Explorer under your data connection, right-click the procedure that you want to change, and then select Open Definition on the shortcut menu.
IBM Procedure Designer toolbar
Use the buttons on the IBM Procedure Designer toolbar to move from view to view in the designer and to perform actions on the SQL or SPL procedure.
- Moves to the Procedure
view
- Moves to the Privileges
view
- Runs the procedure so that you can test it
- Checks the syntax of the procedure by sending a request
to the data server
- 
Runs the DB2 SQL procedure in debug mode so that you can debug it
- Moves to the
Show Script view
See Also
Developing IBM Database SQL and SPL Procedures | IBM Database SQL and SPL Procedures | Creating SQL and SPL Procedures | Changing SQL and SPL Procedure Definitions
.NET Development Forum developerWorks: Visual Studio .NET DB2 FAQs IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.