Just a reminder that COMPILEOPT can be set in the source so that you don't have to remember it every time. Just use set option at the top of your source.
https://dawnmayi.com/2010/01/04/use-rpg-and-sql-together/ Dawn May explaining much better that I ever could.
On Thu, 2021-10-28 at 17:03 +0000, Mark Waterbury wrote:
Justin,
The COMPILEOPT parameter allows you to specify options to be "passed through" the SQL preprocessor to whatever compile command you are ultimately invoking, depending on whether you tell CRTRPGSQLI to create a *MODULE or a *PGM ... (CRTRPGMOD or CRTBNDRPG, respectively).
So, you need to prompt those commands, press F10=Additional parameters, and press F11 to see the keywords, and F9 to ensure you see all of the available options.
A typical use might be (for example):
CRTRPGSQLI ... COMPILEOPT('DBGVIEW(*LIST)')
HTH,
Mark S. Waterbury
On Thursday, October 28, 2021, 12:37:59 PM EDT, Justin Taylor <jtaylor.0ab@xxxxxxxxx<mailto:jtaylor.0ab@xxxxxxxxx>> wrote:
Can anyone point me in the direction of the list of allowed COMPILEOPT
values for the CRTSQLRPGI command? The help says to consult "DB2 for i SQL
programming" on the InfoCenter. If there's a list there, IBM has it hidden
so well I can't find it.
TIA
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx<mailto: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<mailto: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<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
[
https://www.medtronsoftware.com/img/MedtronMinilogo.bmp]
Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550<tel:985-893-2550>
Toll Free: 877-893-2550<tel:877-893-2550>
https://www.medtronsoftware.com
CONFIDENTIALITY NOTICE
This document and any accompanying this email transmission contain confidential information, belonging to the sender that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, or the employee of agent responsible to deliver it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of these documents is STRICTLY PROHIBITED. If you have received this email in error, please notify the sender immediately to arrange for return or destruction of these documents.
midrange.com
