Thanks for the replies and the help!
I should have mentioned that I've written quite a few SRVPGMs and procedures over the years. Learned a lot from an old article (March 2011) in "SystemiNews" by Anders Rhoede. I've used the same structure for all of them: Binding Directory, Binder Source, /COPY members for global values and prototypes. Just add the Binding Directory and /COPY member to the program and off we go.
In this case, the application is a browser replacement for our Order Entry - the front end is developed using CNX Valence App Builder, while the backend is SQLRPGLE. The processes I'm handling simply validate and create/update order header and detail files (called from the CNX Exit program). I was creating separate programs for each file (i.e. one to add/update the header, the detail, etc.) when the user clicks on "Save". The exit program passes a DS representing the entire record format with the new values.
I'm not sure how many service pgms I have on our system (quite a few)... the biggest one contains 78 procedures (7 separate modules) related to our ERP system. I was just going to add these new procedures to a module in that service pgm used for file updates. BUT, I wasn't sure how many procedures is "too many" within the same service program. Do I just add to that service program? Do I create another, separate service program?
This is where I overthink everything.
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Thursday, November 9, 2023 4:51 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Program vs Service Program Procedures
I have the need to write several different programs or procedures to update/create database files in our Order Entry system.
I'm debating whether to write separate RPG programs versus creating a Service Program to contain the same calls to Procedures.
Right now, I see little reason to "reuse" this logic elsewhere. I guess that could change in future as these will operate on our ERP Order Header and Order Detail files.
Is there any significant performance reason to use bound procedures instead of call to separate RPG programs?
I found some older posts on forums that indicate the difference is negligible.
Thanks,
Greg
[Logo]<
https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<
http://www.totalbizfulfillment.com>
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
[CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.]
midrange.com
