×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
That caused the STRSQL session to hang and eventually abend with a record in
use.
This can't be the answer because most of the other programs using the files
will not have any form of commitment control. I am only adding it to this
program so the users can cancel their changes and rollback.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Sam_L
Sent: Wednesday, January 1, 2020 2:15 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: SQL and commitment control
It may depend on how the interactive SQL is started, Does STRSQL COMMIT(*CS)
make any difference?
Sam
On 1/1/2020 12:31 PM,
smith5646midrange@xxxxxxxxx wrote:
I have an RPGLE program that I adding commitment control. When I
insert records to my file but have not yet committed them, I can go to
a second session and using interactive SQL, I can see them. When I do
a rollback in the program, they disappear (as I would expect).
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
