Re: Cross Reference Tools question

["Dee Westerfield" <dwesterfield@xxxxxxxxxx>]

Regular 400 queries are not a problem.  Hawkeye documents them.  It really
is the stuff outside the 400 getting at the data through ODBC or someother
means that is creating the problems.


----- Original Message ----- 
From: "PaulMmn" <PaulMmn@xxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, July 18, 2003 11:11 PM
Subject: Re: Cross Reference Tools question


> We turned AS/400 query over to our users about 10 years ago, and it's
> only bitten us a few times; we have some users who 'experiment' with
> not linking 2 large files together properly, and generating large
> work files...
>
> We do search for all queries using the changed file (I believe we use
> the QMQRY stuff--  retrieve the AS/400 query as QMQRY source, then
> scan the source).
>
> We will hunt down and change any 'production' queries as part of the
> upgrade process.
>
> We will sometimes form a hit squad of programmers and actually go in
> and "touch'n'save" each user query so it updates itself to the new
> file (just to be nice to the users).  Other times, it's email the
> world and alert the help desk.   (:
>
> As far as file downloads, users are advised of the change and are
> given instructions on how to re-up their download definitions.  Users
> don't upload to production libraries.  Most users downloading data
> are 'power' users and are (usually) self-helping.
>
> --Paul E Musselman
> PaulMmn@xxxxxxxxxxxxxxxxxxxxx
>
>
>
> >Dee wrote (in part):
>
> >The issue is how do you document any non-as400 applications that
> >access the data i.e.. Showcase queries,MS Access,Client access
> >downloads. We have taught our users to use Showcase so they are out
> >there doing queries that we don't know anything about and we are
> >making file changes that they don't know anything about. We have
> >been lucky that this has only recently risen it's ugly head.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>