MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2013

RE: query manager query does not update



fixed

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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM 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 here. If you have questions about this, please contact