Re: [WDSCI-L] Data access issue

["colin williams" <colin.williams@xxxxxxxxxxxx>]

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.