File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes WSAD and DB2 stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "WSAD and DB2 stored procedure" Watch "WSAD and DB2 stored procedure" New topic

WSAD and DB2 stored procedure

Nimesh Topiwala

Joined: Mar 24, 2003
Posts: 2
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.
Axel Janssen
Ranch Hand

Joined: Jan 08, 2001
Posts: 2164
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.
Nimesh Topiwala

Joined: Mar 24, 2003
Posts: 2
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???
I agree. Here's the link:
subject: WSAD and DB2 stored procedure
It's not a secret anymore!