CompileOpt are the compile options for the RPG Compiler, i.e. CRTBNDRPG or
CRTRPGMOD (depending on whether you want to compile a Program or Module).
A lot of these compile options can also be set in the H-Specs (CTL-OPT), for
example the Activation Group or Binding Directories to be used.
If you can set them in the H-Spec, there is no need anymore to set them in
the compile command.
The Options set in the SET OPTION Statement are for the SQL Pre-Compiler and
can also be set in the compile command.
If you set those compile options once in the source you never have to
remember them.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Kevin
Bucknum
Sent: Donnerstag, 28. Oktober 2021 19:14
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Valid COMPILEOPT for CRTSQLRPGI
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@lists.midrange.c
om>
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.
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
