RE: Data access issue

It appeared to us that the system did a pass to pick up the physical
files, and then did another pass through all the schemas to pick up
logical file dependencies.  

The other interesting thing was that when we upgraded to 5.1.2, it no
longer loaded stored procedures in the search.  That problem was
rectified when we installed the bundled DB2 (for the Application
Developer Client).


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of colin williams
Sent: Tuesday, October 12, 2004 7:50 PM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Data access issue

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.