Re: SQL database object names longer than 10 characters and mixed case?

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