|
We tried that. It can be (not necessarily is, but*can* be) a recipe for a mess.
We had a logical file used in many programs. I don't recall whether we just made a field mandatory or it was added to the physical file. Regardless, the programs using the pre-existing logical never considered this now critical field. After a couple years, we had to dig into the cause of the problems we had seen arise in the system where the physical file was central. We finally discovered that several programs were ignoring a field not on the logical and leaving us with a bunch of bad data.
Using the technique described can be functional, but just like using LFs referencing the PF file format, you've got to pay attention and do research and modify other programs to keep all your data clean. I've found that even when IO may seem to be so ideally suited to native file access. The more productive route (in the long view) is to use SQL.
Note that in the example above, we would still have had to modify programs to deal with the now critical field. There really aren't any shortcuts to managing the database and system, but overall I have found SQL to be far more efficient. Plus new hires brought in to work on IBM i for the first time, are more comfortable and productive when SQL is used.
Michael Quigley
Computer Services
The Way international
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.