There is an old library, I am going to call it OLDLIB1, that is still in everyone’s library list. I needed to determine if there are files in this library that are still changed. I have used the word “changed” rather than “used” as they mean two different things. A file is used when it is opened in a program, the data within might not be changed. A file is changed when a record is added to the file, modified, or deleted. At present the entire library is saved using the SAVLIB command once a week. But if files are still being used we need to do a more often backup.
I can get to this information using the Display Object Description command, DSPOBJD, but with that I have to build an output file and then search the output file for the information I need.
Fortunately the SQL View SYSTABLESTAT contains the information too in the following columns:
