If you start journaling and commitment control on new programs it will not
affect your old programs.
In RPG (native I/O) you have to explicitly specify the key word COMMIT
within the F-Specs. As long as this key word is not included nothing
changes.
If your SQL Programs are compiled with COMMIT(*NONE) nothing will change,
... but when recompiling make sure they are again compiled with
COMMIT=*NONE.
The easiest way is to add a SET OPTION statement in each (embedded SQL
Source) with the commit key word (COMMIT=*NONE or
COMMIT=AnyOtherCommitLevel).
SET OPTION overrides the compile command, so you'll never have to remember
which program/module has to be compiled with Commitment Control and which
one not.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"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)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
midrange-announce@xxxxxxxxxxxxxxxxxx
Sent: Friday, 1 December 2023 13:30
To: RPG400-L@xxxxxxxxxxxxxxxxxx
Subject: Guidelines for RPG400-L mailing list
Monthly posting of the guidelines for participation in the RPG/400 Language
Mailing List.
Keep to the subject. The topic of the list is RPG/400 Programming. This
includes, but is not limited to, all aspects of RPG programming (ILE and
OPM), activation groups, indicators (fie!), extensions, enhancements,
debugging, etc.
When quoting messages, do not quote the entire message. Just quote the
parts that are needed to make the appropriate references.
Flames are absolutely prohibited. If you disagree with someone, feel free
to argue the facts, but no personal attacks will be tolerated.
Political discussion is completely inappropriate for this, and most,
midrange.com hosted lists.
The official language of the RPG/400 Programming Mailing List is English.
Do not post personal messages. Please use direct E-Mail. This list is
international in scope and personal messages just end up costing money.
When starting a new discussion thread, *PLEASE* try to avoid replying to an
existing message to get the correct email address. When you reply to an
existing message, most email clients and the list archiving software think
that the new thread is part of the old thread, and will display it as such.
While the participants of this list are happy to answer questions and help
solve problems, it is greatly appreciated if you do some of your own
research beforehand. Before posting a question for the first time, please
take a moment to review Eric Raymonds excellent FAQ "How to Ask Questions
the Smart Way" (
http://www.catb.org/~esr/faqs/smart-questions.html).
Advertising products or services (including press releases) are strictly
prohibited. Also, if you have a solution that will specificly help another
participant, feel free to tell that person. And finally, if you are a
vendor, please identify yourself as such... do not try to pass yourself off
as a user of your own products (even if you are).
Employment related discussions are off-topic in this technical discussion
forum. Please restrict abstract employment discussion to MIDRANGE-L and
specific employment discussion to MIDRANGE-JOBS.
PLEASE NOTE: When posting to the list, any personally identifying
information in your message will be included in the list. Email addresses,
however, are masked when being formatted for the list archives. If you
include a standard signature in all messages, consider using the internet
standard for signature separator (as defined in RFC 3676,
http://tools.ietf.org/html/rfc3676) of '-- ' (that's dash dash space). The
list archiving software will automatically stop including the message when
it encounters the marker.
PLEASE do not report list messages to your mail providers abuse / spam
department. This results in a black mark against midrange.com and,
depending on the mail provider's policies, can cause mail delivery delays
for everyone who uses both midrange.com with that mail provider.
midrange.com does treat abuse reports very seriously and acts upon them
immediately. When abuse reports are received, and the reporting person can
be identified, they will be removed from all lists immediately ...
and then a follow-up email will be sent.
If you wish to be unsubscribed from a list and cannot do so through the
normal mechanisms (identified at the bottom of every list message), please
contact the list owner or support@xxxxxxxxxxxxxxxxxxxx for assistance.
When posting a long weblink (URL), consider using
http://bitly.com to
shorten it. Some mail programs wrap long text and cause URL's to break.
By posting to this mailing list, you are granting MIDRANGE.COM and David
Gibbs (david@xxxxxxxxxxxx) perpetual, non-exclusive, unlimited, and
irrevocable, rights to the content.
This list IS copyrighted as a compilation. Republication of this mailing
list, for anything other than personal use, without the explicit permission
of the list owner is a violation of U.S. Copyright Law and will be dealt
with as such.
Collecting or "Mining" of email address from this forum, or any related web
archive, is strictly and explicitly prohibited (not to mention that it is
extraordinarily unprofessional).
Violation of the above guidelines will be determined by the moderator and
will result either a) The offending party will be forced to make major
modifications to a 10 year old, matching records, RPG II program that uses
every available indicator or b) permanent disconnection from the conference
(you decide which is worse).
To subscribe, unsubscribe, or change mailing list options, please vist
http://lists.midrange.com/mailman/listinfo/RPG400-L
If you have questions or comments about these guidelines, please feel free
to contact the moderator, David Gibbs via internet e-mail at
rpg400-l-owner@xxxxxxxxxxxxxxxxxx.
MIDRANGE dot COM is a non-commercial organization and is not connected with
any corporation, periodical, or commercial enterprise. For more
information, send Internet E-Mail to support@xxxxxxxxxxxx.
midrange.com
