Re: Using Embedded SQL in RPGLE or Creating SQL Functions

As Dr. Donald Knuth, dean of American computer science, famously said, "Premature optimization is the root of all evil."
You're right, Richard, to start coding your SQL inline in RPG.
And after it's all debugged, you can tuck it away in a sproc or func.

________________________________
From: RPG400-L <[email protected]> on behalf of Richard Schoen <[email protected]>
Sent: Saturday, March 21, 2026 08:47
To: [email protected] <[email protected]>
Subject: Using Embedded SQL in RPGLE or Creating SQL Functions

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Another interesting philosophy question.

When embedding SQL calls in RPG I have seen two schools of thought.

-Embed your SQL processing into your RPG code.

-Embed you SQL processing into the DB itself: Stored Process/SQL Functions, etc…. and call those from RPG.


Jack WoehrIndependent Consulting Programmer 303-847-8442 [email protected] www.procern.com Stay Connected!Upgrade your IT state of mind!NON-DISCLOSURE NOTICE: This communication including any and all attachments is for the intended recipient(s) only and may contain confidential and privileged information. If you are not the intended recipient of this communication, any disclosure, copying further distribution or use of this communication is prohibited. If you received this communication in error, please contact the sender and delete/destroy all copies of this communication immediately. 
-- 
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: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.