For the record, this issue was resolved by compiling the
CLLE with *CALLER
This is required because we developed this program to be
called by a 3rd party application as a "user function".
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Tuesday, September 24, 2013 1: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,
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
