That SQL option is already in there. First executable line of code.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of TheBorg
Sent: Friday, April 05, 2013 2:02 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Embedded SQL locking files?
Thomas -
read up on SET OPTION.
perhaps
exec sql SET OPTION CLOSQLCSR = *ENDMOD;
will solve the problem.
-sjl
"Thomas Garvey" wrote in message
news:mailman.1382.1365187546.7202.midrange-l@xxxxxxxxxxxx...
Anyone ever see an RPGLE program with lots of embedded SQL that somehow
manages to lock records of logicals never referenced in the logic? By
'never referenced' I mean that no inserts/updates/deletes are included for
the physical file involved, or any of its logicals.
No commitment control, no updates, but still locks records. How? Why?
Thomas Garvey
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
