I am trying to create a DB2 stored procedure in WSAD. I will appreciate if someone can help me to get this going. In data perspective, I connect to DB2 and "Import (Schema) to Folder" Then in data perspetive I expand up to scema and I see a folder called "Stored Procedure" I right click on this floder and select "New" option to add a new store procedure. I find two options of "SQL Stored Procedure" and "Java Stored Procedure" BUT both are disabled. I did make sure that the user id I am using to connect to DB2 has CREATE PROCEDURE permission. I am trying to crerate a new store procedure using WSAD and I haven't been able to do so. I will really really appreciate if someone can help me. Thanks Nimesh
o.k. this does not answer your question. I've never used the stored procedure builder of wsad. But you know that dev-client of db2 has a Stored Procedure Builder? As I've used this tool found it quite o.k. You may then access the stored procedure from your code in wsad. No problem.
Thanks for providing an alternative to create a stored proc., but I am still looking to create a stored proc. through WSAD. I am trying to follow the following steps given in WSAD help: To create a stored procedure using the wizard: 1) Switch to the Data perspective. 2) In the Data Definition view, create a DB2 database definition or import a DB2 database definition from the DB Servers view.
3) In the Data Definition view, right-click the Stored Procedures folder, and click New > SQL Stored Procedure or New > Java Stored Procedure. The New Stored Procedure wizard opens. 4) Complete the necessary steps of the wizard. 5) Click Finish. The stored procedure is created and added to your database definition. Two options mentioned in step #3 are disabled. That is my problem. Can anyone help???