RE: [WDSCI-L] Stored Procedures

["Dean, Robert" <rdean@xxxxxxxxxxxx>]

iSeries/Operations Navigator may be a better interface for working with
these sorts of database objects, but there are still tasks that could be
helped by having a full-featured Data Perspective.  WSAD/WDSC provides
tooling to automatically generate Java Beans or EJB method calls from a
stored procedure.  To do this requires setting up a connection and
having the Data perspective import the definitions.

This worked very well in WDSC 5.1.0.x, but it appears to be broken in
WSAD 5.1.2 with respect to stored procedures.  We set up a filter with
the intent of using the wizard to generate JavaBeans for stored
procedures, but it skips discovery of stored procedures no matter what
filter criteria or version of JT/400 we use.  The iSeries systems are
V5R2.

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Vern Hamberg
Sent: Tuesday, August 03, 2004 9:53 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Stored Procedures

I believe this client is on a DB2 Connect CD bundled with WDSC.

The Data Perspective is not tailored for the iSeries - e.g., logical
files 
do not show up under the Indexes item. And if you DO use it, be sure to
set 
the filter to only a single library (database in the terms of WDSC) or a

few libraries. I've read, IIRC, that OpsNav may be a better interface
for 
working with these things.

hth
Vern

At 08:00 AM 8/3/2004, you wrote:

>Under the Data Perspective, the option for "SQL Stored Procedure" is 
>greyed out under the New selection.  If I select "SQL Stored Procedure"

>under the New wizard, I get the following message: "To use this
feature, 
>you must install the DB2 Application Development Client".
>
>So, What am I missing?  What is this client talked about in the error
message?
>
>Thanks,
>     Scott J.
>_______________________________________________
>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.


_______________________________________________
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.