|
As usual with the AS/400 everyone in these discussions is ignoring the 300
pound gorilla in the room, database independence.
When you use RLA, unless you externalize your I/O somehow (which almost no
one know how to do and won't use it even if you did), you are bringing the
entire record into the program which in effect, locks the table to change.
That means the next time you need to change the table you have to recompile
every program that uses it and very quickly no wants to recompile 500
programs so they start creating extension tables or reusing fields or god
knows what.
If you are using SQL and bringing only what you need that table is still
independent. You can add additional data elements and not have to recompile
the entire world.
So do you really want to save a few billionth of a second by using RLA and
then spend god knows how many programmer hours trying to get around the fact
that you have hardwired your database into every program in the system?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.