Re: [WDSCI-L] created stored procedure

[Larry Schweyer <schweyer@xxxxxxxxxx>]

I think you need to install the "Application Development Client" that is on
the DB2 CDs.
It is mentioned as a prereq. in the help if you do a search on "stored
procedures".

Larry Schweyer
iSeries AD, IBM Toronto Lab
schweyer@xxxxxxxxxx
(905)413-4084 Tie-line: 969-4084




                                                                           
             Robin.Li@microage                                             
             solutions.com                                                 
             Sent by:                                                   To 
             wdsci-l-bounces@m         wdsci-l@xxxxxxxxxxxx                
             idrange.com                                                cc 
                                                                           
                                                                   Subject 
             02/18/2004 11:09          [WDSCI-L] created stored procedure  
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                 Websphere                                                 
                Development                                                
             Studio Client for                                             
                  iSeries                                                  
                                                                           
                                                                           




Hi,

Did anyone use WDSc to create a Stored Procedure ?
I followed the instructions in the Help, as the following:

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.      If you created the DB2 database definition (as opposed to
importing it), then right-click on the database definition and click New >
New Schema Definition.
4.      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.
5.      Complete the steps of the wizard.
6.      Click Finish. The wizard creates the stored procedure and adds to
your database definition.


However, in step 4, right-click on the Store Procedures folder, the SQL
Stored Procedure and Java Stored Procedure are not highlighted, which
means I
cannot select either of them. Is there anything missing for me that caused
the problem? My WDSc is on V5.1for Iseries Advanced Edition  with all the
latest fixes.

Any suggestions are appreciated.


Robin

_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.