Tools to develop stored Procedures
From SQL PL Guide for DB2
Contents |
Tools to develop stored Procedures
IBM Data Studio
Typically the IBM Data Studio is used to develop and deploy stored procedures. The tool supports DB2 V8.x, DB2 9.1 ,and DB2 9.5. With the IBM Data Studio you're able to build, test, deploy, and optimize SQL or Java stored procedures to improve application performance and availability. The tool is available on the IBM website.
Previous Tools
In previous database releases the Developer Workbench (DB2 9), the Development Center (DB2 V8) and the Stored Procedure Builder were shipped with the DB2 database.
Manually deploying
Of course it's possible to create manually a stored procedure without any GUIs or tools. You're just need an editor like vi (Unix/Linux) or notepad (Windows).