RE: query -- MIDRANGE-L

This makes me think of one thing to be careful of - if any of the files have indexes, whether physical of logical files, then they might have been used by the optimizer and never show as used in the object description - esp. LFs. This would apply to SQL-type activity, which can include OPNQRYF and Query/400 queries, as well.

OTOH, it seems that if a PF has an index (is keyed), there is little chance that the use of that index by the optimizer would preclude the use of the actual PF in retrieving the data. If that made any sense, don't blame me, I've not been well. :-)

Regards
Vern

At 01:04 PM 12/21/2004, you wrote:

Here's what I would do:
1) First Display Object description and put it in a file. Than you can run a query over it for the desired information.
Example:
Display Object Description (DSPOBJD)

Type choices, press Enter.

Object . . . . . . . . . . . . . > *ALL Name, generic*, *ALLUSR... Library . . . . . . . . . . . > *ALL Name, *LIBL, *USRLIBL... Object type . . . . . . . . . . > *FILE *ALL, *ALRTBL, *AUTL... + for more values Detail . . . . . . . . . . . . . > *FULL *BASIC, *FULL, *SERVICE Output . . . . . . . . . . . . . > *OUTFILE *, *PRINT, *OUTFILE File to receive output . . . . . dspobjuse Name Library . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB Output member options: Member to receive output . . . *FIRST Name, *FIRST Replace or add records . . . . *REPLACE *REPLACE, *ADD
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Muralidhar Narayana
Sent: Tuesday, December 21, 2004 12:50 PM
To: midrange-l@xxxxxxxxxxxx
Subject: query
I want to generate a list of files in a library that have not been used since Oct of 2000. Only the files which doesnt have logical dependancies.
Thanks in advance,
--
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.
--
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.