Re: RLA & SQL was (Re: SQL database object names longer than 10 charactersand mixedcase?)

Hi Paul,


agreed, its possible (nearly nothing is impossible, its always a question
of
effort), but I never saw commit used with RLA, ist even rarely used with
SQL, thow its rather easy to use with SQL; thats one point, where the RPG
community is far away from state of the art and it has something to do
with RLA!?

I use commitment control with RLA all the time. Not having to reverse
updates halfway through a transaction is fantastic! And it's not really
all that hard. The harder part is when you have legacy code that doesn't
use commitment control and new code that does - but even that can be done.

Really, the discussion is now getting to be that you shouldn't use RLA
because you should only use one technique and that technique should be
SQL. It's not a particularly strong argument.

The truth is that SQL is better for some things, RLA for others. Any
other argument is a matter of personal bias.

Joe