× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Opposing view...

First, the obvious and probably not under dispute... ALL changes, improvements, performance, advances are made only in SQL. Define all tables in SQL DDL. IBM stated this more than a decade ago. This can be done now, and does not require changing applications.

Continued use of RLA for I/O, ties your database interminably to the past and makes moving forward with your database no better than any other time in the past since you are at the mercy of the format level identifier. You are tied to the physical representation of your tables and this is one of the reasons that people still see IBM i OS as "old and outdated". It's also one of the tenants of Relational Technology... separate your applications from the physical representation of the data.

While IBM i OS RLA applications call for recompilations every time we make a change to the database, the Oracle, MySQL and SQL Server people have already altered their tables and are accommodating requests for change while we wait for a good time to take the machine "down" and recompile the world.

Additionally, you can't use index-only access from RLA. You can't take advantage of EVIs. You don't have as much control over what fields are actually retrieved and or updated by your applications.



On 10/31/2010 04:03 PM, Joe Pluta wrote:
I'm not trying to change YOUR mind, Dieter. I'm just making sure
opposing views are heard. Although I notice you don't actually address
my objection, you just dismiss it out of hand. :)

... that doesn't change my mind in any point!!!

--------------------------------------------------
From: "Joe Pluta"<joepluta@xxxxxxxxxxxxxxxxx>
And I disagree in the strongest terms possible. Unless you plan on




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.