RE: BIG Query Question

There currently is no API to determine what files are used within a query. 
 This is a known requirement with the most common suggestion from users 
being to allow a query to participate in DSPPGMREF.

Bruce




"Chuck Lewis" <chuck.lewis@xxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/12/2006 09:26 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: BIG Query Question






Sweet Jim,

At least I can pull together a list of files used in what queries and if
they can tell us what files are changing, we can just concentrate on 
those.
Better than redoing ALL of them :-)

But you do REALLY WISH IBM would come up with some way of doing this...

Thanks !

Chuck

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Franz
Sent: Monday, June 12, 2006 9:56 AM
To: Midrange Systems Technical Discussion
Subject: Re: BIG Query Question

I have asked same question several times over many years
and not got an answer that such an api exists. Would be
great if it does, but I have to deal with this over many times.
I do have a way to identify which files and fields in use by a query
(thru rtvqmqry cmd you can create a source mbr of a *qrydfn qry)
jim franz