If you really want to do all of those things, you may want to take a look at ORM's (Note: this is not an RPG thing but is a tool used by most other languages like Java/C#).
The only language I know of that has brought ORM methodology to the "next level" though is .NET as they have LINQ (Language Integrated Query) which allows you to query any object as if it was a SQL table using familiar constructs.
This is just a short example of linq:
https://mathewrphillips.wordpress.com/2012/02/17/why-linq-is-awesome/
A recent project we did, where by we removed all SQL querys and instead transferred it an ORM and utilize LINQ reduced our C# code base for that one project by 34.5%! We now do not have a single line of SQL code in those programs as the ORM generates all the SQL querys on the fly based off of your data model that you define once, and can reuse everywhere. That is developer productivity! Want to change your model? OK, when you do you will get compile time checking of every LINQ query and it will tell you if anything is wrong BEFORE you run your program. How many times did you put a typo in your embedded SQL in RPG? That is a thing of the past with ORM's.
NOTE: You do loose a bit of performance, but it is negligible. For the millions you will save in consultant / developer hours you can buy those new shiny SSD's you've always been wanting to make up the performance drawback.
-----Original Message-----
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Friday, September 15, 2017 2:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Database I/O Modernization
On Fri, Sep 15, 2017 at 12:51 PM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:
May I remind you about the topic, we are discussing: "Database I/O
Modernization"!!! It was your choice, not mine. RLA might be the right
tool for some job (I suspect it is) but it is by far not the right
tool for Database modernisation!!!
Different people will have different definitions for "modernization". My definition would include anything that improves applications. The improvement may come in the form of better performance, more programmer productivity, making applications more adaptable to change, improving the modularity or readability of code.
You shouldn't exclude RLA from modernization.
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://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
midrange.com
