You do a COMMIT after the QM query ends so I believe you do this but am asking just o cover all the bases: Do you do a STRCMTCTL before running the QM query and an ENDCMTCTL after the COMMIT?
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Tuesday, September 24, 2013 12:21 PM
To: Midrange Systems Technical Discussion
Subject: query manager query does not update
We use Query manager queries fairly often, but not so much with files under commitment control.
We have a table that is journaled and a CLLE program calling a QM query and passing parameters to update the status of a particular row.
When control returns to the CLLE, a COMMIT is issued.
The job log shows the parms passed to the QM Query and the COMMIT command, but a subsequent check of the table shows the status of the row is unchanged ?
Running a similar update from STRSQL does successfully update the row in the table.
Is it as simple as adding a COMMIT to the existing QM Query ?
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l