[WDSCI-L] Re: database perspective

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Ok, that was the trick.... When I tried to enter the filter, the predicate
was setting NOT LIKE.  Setting the filters correctly allowed the connection
to complete in seconds.... Thanks.  :)

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Don Yantzi [mailto:yantzi@xxxxxxxxxx]
Sent: Friday, March 28, 2003 3:31 PM
To: Websphere Development Studio Client for iSeries
Subject: [WDSCI-L] Re: database perspective


Eric,

Have you tried creating a new database connection, or are you trying to 
reuse the old one?  What are you entering for your filter criteria? 

Make sure when you specify the filter to change the predicate to LIKE (the 
default is NOT LIKE.)   For example to include only library ABC you need 
to create a filter with:

Target:                 SCHEMA 
Filter:         ABC 
Predicate:      LIKE 

Hope this helps.

Don Yantzi
WebSphere Development Studio Client for iSeries
IBM Toronto Lab
Phone: (905) 413-4476
IBM internal:  IBMCA(yantzi)  -  Internet: yantzi@xxxxxxxxxx





"DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
03/28/2003 03:54 PM
Please respond to Websphere Development Studio Client for iSeries 
 
        To:     "'Websphere Development Studio Client for iSeries'" 
<wdsci-l@xxxxxxxxxxxx>
        cc: 
        Subject:        [WDSCI-L] Re: database perspective

 

Don,

I definitely missed your article.  My problem relates to this, in that 
now,
regardless of selected filters, I still get stuck loading the "meta-data".
It's like it know's that I once tried to connect with NO filters, and it's
still trying to load that stuff.  How can I reset that?

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Don Yantzi [mailto:yantzi@xxxxxxxxxx]
Sent: Friday, March 28, 2003 1:09 PM
To: Websphere Development Studio Client for iSeries
Subject: [WDSCI-L] Re: database perspective


Phil,

You can use the database perspective with your iSeries.  When creating the 

connection make sure you select the iSeries JDBC driver (you can find the 
required jar file in 
c:\wdsc\wssd\eclipse\plugins\com.ibm.etools.iseries.toolbox\runtime\jt400.ja
r 
).  Also make sure you specify a filter when you create the database 
connection, like filter for a specific schema.  Otherwise the tool tries 
to download the metadata for the entire database and there is only one 
database so it takes about an hour!

FYI:  I wrote an article on using the Database tooling with the iSeries in 

the December 2002 eServer magazine if you are looking for some more 
information.

Don Yantzi
WebSphere Development Studio Client for iSeries
IBM Toronto Lab
Phone: (905) 413-4476
IBM internal:  IBMCA(yantzi)  -  Internet: yantzi@xxxxxxxxxx





sublime78ska@xxxxxxxxx
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
03/28/2003 01:20 PM
Please respond to Websphere Development Studio Client for iSeries 
 
        To:     wdsci-l@xxxxxxxxxxxx
        cc: 
        Subject:        [WDSCI-L] database perspective

 

I'm trying this for the first time.

Do I need DB2 installed on my PC to use this?  Hope not, unless it's part 
of WDSc.

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

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