Re: Database I/O Modernization

Not really. You are limiting SQL. This allows a single table. What happens
if I need to join together three tables. With SQL, I just write the
statement or create a view.

There is a way to write these things that is high efficiency and multiple
tables but again why bother if you have SQL.

And the basic problem is here that if you are stuck in the past and still
using RLA instead of SQL why would you use procedures? You wouldn't. You
would avoid them like the plague. That's why IBM had to come up with OA.

Anything you can do in OA you can do as good or a lot better in a procedure
and a service program but IBM knew that most RPG programmers would never
use a procedure so they created OA.

Companies I used to work at I would write service programs but the
programmers demanded that I write a callable program wrapping the procedure
because they would not touch a procedure. Same thing were ever I have been.

On Fri, Sep 8, 2017 at 3:45 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

On Fri, Sep 8, 2017 at 4:02 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

Pretty easy answer. None. Use SQL. IBM has spent unknown millions of
dollars developing SQL which does the same times a thousand. Record I/O

is

obsolete. Let it go.

Alan, if I understand correctly, you object specifically to the use of RPG
op codes. But what about the procedure interface implemented in the service
program?

If the RPG op codes were replaced with SQL, would the procedure interface
meet with your approval?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD