Re: RPG Service Program vs Include Source for Shared Subprocedures and SQL Calls

Buck Calabro <[email protected]> Sat, 21 Mar 2026 07:54:36 -0400
Newsgroups gmane.comp.lang.as400.rpg
Message-ID <CACMm6qB+W=kskSjkn_+rrzyEDVG+r8f5n1TJPKtgCh71qOzQ=Q@mail.gmail.com>
Richard said:

> In the past I've leaned towards copybooks, but I'm curious what others think.

I'm solidly in the *SRVPGM camp.
When a customer has developers with pre-ILE skills, it's an
opportunity to introduce them to how easy it is to use a *SRVPGM.


> I'm a little cautious of burying SQL functionality into one or more service programs.

Virtually all of our service programs use embedded SQL. I haven't
found that more problematic than F-specs.
With so many edge case shops, it's unfair of me to generalise so I
have to ask: have you encountered a situation where SQL in a service
program has been an issue?

  --buck
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.