× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.