× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.






Colin
Thanks for the reply. It is true, it loads only those tables/schema
requested. But while loading it keeps saying loading every view of the
tables in the schema/library selected. This process runs for a long time
(at-least 10 min.) for even for 3 or 4 tables selected. I like the data
access, and I am contemplating of using as an interactive SQL. In case of
such an usage, should I have to create a new connection under DB servers.
My question is whether I could change/include new tables either under " DB
Server "  or under  "Data definition ".


Thanks
Jag




                                                                                
                                                         
                      "colin williams"                                          
                                                         
                      <colin.williams@be         To:      "Websphere 
Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx>       
                      rtrams.com>                cc:                            
                                                         
                      Sent by:                   Subject: Re: [WDSCI-L] Data 
access issue                                                
                      wdsci-l-bounces@mi                                        
                                                         
                      drange.com                                                
                                                         
                                                                                
                                                         
                                                                                
                                                         
                      10/12/2004 07:50                                          
                                                         
                      PM                                                        
                                                         
                      Please respond to                                         
                                                         
                      Websphere                                                 
                                                         
                      Development Studio                                        
                                                         
                      Client for iSeries                                        
                                                         
                                                                                
                                                         
                                                                                
                                                         




Jag,

I have found that it still appears to load the complete schema, but when
you
look at  the details for the underlying tables, only the ones you have
selected will have been fully loaded

cheers
Colin.W

----- Original Message -----
From: <jag@xxxxxxxxxxxxxxxx>
To: <wdsci-l@xxxxxxxxxxxx>
Sent: Tuesday, October 12, 2004 9:00 PM
Subject: [WDSCI-L] Data access issue


>
>
>
>
> I am trying to use data access perspective and while setting up the
> connection under DB server, I am applying filter on SCHEMA and as well as
> on TABLE. Both the parameter are connected together with an " AND ",
> Despite this filter setting, JDBC loads all the schema.
>
> eg. (SCHEMA NOT LIKE QSYS% AND SCHEMA LIKE LIBNAME1 ) AND (TABLE LIKE
> FILE01 OR TABLE LIKE FILE02 ). System appears to loads complete SCHEMA.
Am
> I doing something wrong or missing something.
>
> Jag
>
> -=- A. Schulman Inc. Email Disclaimer -=-
>
> The content(s) of this e-mail and attachment(s) are confidential, may be
> legally privileged and is for the use of the intended recipient only.
> Access, disclosure, copying, distribution or reliance on any of it by
> anyone else is prohibited.  If received in error, please delete and
e-mail
> confirmation to the sender.
>
> A. Schulman Inc. does not guarantee that the information sent and/or
> received by or with this e-mail is correct and does not accept any
> liability for damages related thereto.
>
> _______________________________________________
> 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 e-mail has been sent by a company of Bertram Group Ltd, whose
registered office is 1 Broadland Business Park, Norwich, NR7 0WF.
This message, and any attachments, are intended solely for the addressee
and may contain privileged or confidential information.  If you are not the
intended recipient, any disclosure, copying, distribution or any action
taken or omitted to be taken in reliance on it, is prohibited and may be
unlawful.  If you believe that you have received this email in error,
please contact the sender immediately. Opinions, conclusions and statements
of intent in this e-mail are those of the sender and will not bind a
Bertram Group Ltd company unless confirmed in writing by a director
independently of this message.
Although we have taken steps to ensure that this email and any attachments
are free from any virus, we advise that in keeping with good computing
practice the recipient should ensure they are actually virus free.

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




As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.