That caused the STRSQL session to hang and eventually abend with a record in

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?


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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support by shopping at with our affiliate link:

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.