RE: query manager query does not update

Gary,

We do STRCMTCTL/ENDCMTCTL in the main job CLLE,
which calls the CLLE that runs the QM Query I
mentioned in my post.

In the job log I see STRCMTCTL LCKLVL(*CHG)
before the call to the CLLE that runs the QM
Query.

I see a COMMIT issued by the second CLLE, which
then returns to the main job CLLE.

I see the main job CLLE issue an ENDCMTCTL just
before the job completes.

So I am missing something, but thanks for checking
those details.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Monnier, Gary
Sent: Tuesday, September 24, 2013 1:37 PM
To: Midrange Systems Technical Discussion
Subject: RE: query manager query does not update

Gary,

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?

-----Original Message-----
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,
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.

--
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.