Re: RPG SQL and Cursors -- RPG400-L

... we where talking about design rules and not special situations, which could occur. Breaking a design rule twice, would be no problem, if it gets encapsulated.
Using SQL you could code an isolation clause for nearly each statement to adjust the locking mechanism; I don't know about this feature for RLA, but maybe I'm missing something at this point, didn't use it for years :)))
SQL is a strongly typed language and every assignment or compare is type checked at compiletime (if you use static SQL) and at runtime too. RPG has no concept of type binding (not really) latest point OVERLAY in a DS would allow every nonsens, you could think of. Using a DS for update or write is treated very diffrent between RLA and SQL, SQL resolves the DS at compiletime to single fields, RLA does not. There are many discussions out there between thediffrences of SQL and DDS created tables, I don't want to discuss further, just another discussion about microseconds, waisting hours of programmer productivity...

Dieter

--------------------------------------------------
From: "Christen, Duane" <Duane.Christen@xxxxxxxxxx>
Sent: Friday, November 19, 2010 7:34 PM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: RE: RPG SQL and Cursors

Dieter;

Mixing SQL and RLA to process the same file/record set, is something to shy away from IMO, but I have broken that rule twice, because it fit the situation.

You CAN have more granular control of a transaction with SQL but it is not easier with SQL. I don't know what you mean by record locking being more flexible or easier???

SQL CAN be more loosely coupled to the database but you can couple SQL as tightly to the DB as RLA (*).

I would like to know what this means, "SQL does more type checking at compiletime and at runtime" because AFAIK it is the DBMS that does all of the type checking at runtime, and both compilers attempt to keep you from miss typing columns.

Duane Christen

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of dieter.bender@xxxxxxxxxxxx
Sent: Friday, November 19, 2010 10:05 AM
To: RPG programming on the IBM i / System i
Subject: Re: RPG SQL and Cursors

- using one technology is easier than mixing up two
- transaction handling and record locking is more flexible and easier to
maintain with SQL
- SQL access is looser coupled to the database than RLA
- SQL does more type checking at compiletime and at runtime

Dieter

--------------------------------------------------
From: "Aaron Bartell" <aaronbartell@xxxxxxxxx>
Sent: Friday, November 19, 2010 4:33 PM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: Re: RPG SQL and Cursors

And why not? Say you had an app with a list of records that the user was
allowed to sort by any column and specify search criteria in a text input
at
the top - that is much easier to code in SQL than RLA in my opinion, but
then when it comes time to edit one of the result records and update it,
well then I go back to RLA.

Aaron Bartell
www.MowYourLawn.com/blog
www.OpenRPGUI.com
www.SoftwareSavesLives.com

On Fri, Nov 19, 2010 at 9:13 AM, <dieter.bender@xxxxxxxxxxxx> wrote:

... I wouldn't use a mix of RLA and SQL, but maybe thats a question of
flavour and I'm tired of discussions about microseconds.

Dieter

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.