× 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.



... 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

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

I use a balance of RLA and SQL. Usually use RLA by default and only go to
SQL when it is a better fit (i.e. dynamic sorts, searches, ranges, etc). We
are actively moving our web development (i.e. OpenRPGUI.com) from our V5R3
server to our V6R1 server so I am planning on jumping into free form
embedded SQL, and on that note...

Are there any well documented (i.e. articles) out there that show how a CRUD
application would use embedded SQL for all file access? I ask not because I
am new to SQL, but because I am not yet convinced of how it's usage is being
described by some in this thread.

I must say that Alan's comments about lessening the compile burden is
something I hadn't considered to a great extent until I started thinking
about it. Certainly better that wrapping file access with *SRVPGM's where
the whole record is being passed in/out without applying any sort of
business logic. I think this also comes down to having a good change
management solution that does a lot of the work for you (as it should).

Aaron Bartell
www.MowYourLawn.com/blog
www.OpenRPGUI.com
www.SoftwareSavesLives.com
--
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.



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.