Re: Data connection doesn't return any tables

I tried filter 

        SCHEMA LIKE XXX%10

but it is working like

        SCHEMA LIKE %10

seems to be ignoring the XXX part

 



Anita Leung <leunga@xxxxxxxxxx> 
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
09/24/2004 04:02 PM
Please respond to
Websphere Development Studio Client for iSeries<wdsci-l@xxxxxxxxxxxx>


To
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
cc
wdsci-l@xxxxxxxxxxxx, wdsci-l-bounces@xxxxxxxxxxxx
Subject
Re: [WDSCI-L] Data connection doesn't return any tables










What JDBC driver are you using? Try with a Toolbox JDBC driver,
com.ibm.as400.access.AS400JDBCDriver, where you can get it from jt400.jar
in the com.ibm.etool.iseries.toolbox plugin.

Regards,
Anita Leung
iSeries Web and Java Development Tools
IBM Toronto Laboratory
Phone: (905)413-4215, Tie-Line: 969-4215
leunga@xxxxxxxxxx




 
             <Rick.Chevalier@a 
             mericredit.com> 
             Sent by:                                                   To 

             wdsci-l-bounces@m         <wdsci-l@xxxxxxxxxxxx> 
             idrange.com                                                cc 

 
                                                                   Subject 

             09/24/2004 04:21          [WDSCI-L] Data connection doesn't 
             PM                        return any tables 
 
 
             Please respond to 
                 Websphere 
                Development 
             Studio Client for 
                  iSeries 
 
 




I am trying to setup a JDBC connection to our iSeries.  I followed the
instructions in the help text for how to create a connection and set the
filter.  If I make any changes to the default filter nothing is returned.
There are no error messages, just an empty list.

I am setting up the filter as SCHEMA LIKE libraryname%.

Can anyone help with how to get the filter to return something other than
the default?  Has anyone else successfully created their own filter in the
database servers view?

Rick Chevalier
 <<ole0.bmp>>
Enterprise Solutions
Ext. 57178

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