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

[Alan Campin <alan0307d@xxxxxxxxx>]

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