Re: RPG easier/harder to use than other languages?

The problem with stored procedures is that they have parameters and
parameters are inflexible. You can use SQL to return result sets but what
happens when you try to send large amount of data or complex data? As
someone who has spent 25 years building or fixing or reviewing the messes
that get created it is unbelievable what you see. I call it the round hole,
square peg syndrome. Hit it with a hammer until it fits. Web services are
better but what happens is that you create a web request, send it to the
iSeries where it gets converted into parameters for program calls. Right
back to round hole, square peg. .

On Fri, Jul 7, 2017 at 8:05 AM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

I think the question was stored procedures vs other methods (e.g.
webservices).


-----Original Message-----
From: Richard Schoen [mailto:Richard.Schoen@xxxxxxxxxxxxxxx]
Sent: Friday, July 07, 2017 8:56 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: RPG easier/harder to use than other languages?

You question was directed at Buck, but here's my opionion FWIW.

In .Net, PHP, Ruby, etc. it's almost always a good idea to call business
logic as stored procedures where the logic is tied to a specific database
whether IBMi, SQL Server or Oracle.

This practice is quite common with Oracle, SQL Server, so it also makes
sense to use same context with IBMi to call business logic.

I don't think management probably needs much convincing to use sprocs.

Leave the business logic where it's at and call as needed from wherever.

Regards,


Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.

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