RE: Determine name of query that created data file

["Lapeyre, Francis" <FLAPEYRE@xxxxxxxx>]

Once I had level check on a normally stable program. The file in question
had not been changed lately, nor had the program, so I was puzzled -- until
I looked more closely at the message and saw that the file in question was
in QGPL, and not the data library (QGPL was the second library on the
library list, right after QTEMP). Somebody created the file with Query (with
the same name as the production data file); I renamed the file, answered the
message, and found out who created the QGPL version by doing a DSPFD on it,
and admonished him to not create files in QGPL. We have libraries we create
for users to create their own queries and the files generated thereby, and
he apparently forgot about that memo. We have since locked down QGPL and the
data libraries so people can't create new files there anymore. 

In any event, I suppose you need to work backwards - find the owner of the
file with DSPFD, then look for *QRYDFN objects that user created, and look
at the output files they create.

Francis Lapeyre
IS Dept. Programmer/Analyst
Stewart Enterprises, Inc.
E-mail: flapeyre@xxxxxxxx 



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Erin Botkin
Sent: Monday, October 31, 2005 3:32 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Determine name of query that created data file

Does anyone know who to determine the name of a query that created a data
file?

Erin K. Botkin
Application Analyst
Spotsylvania County
Information Services
PHN: 540-582-7055 ext. 232
FAX:  540-582-9840

ebotkin@xxxxxxxxxxxxxxxxxx