|
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 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.