Thanks for that Chuck
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Wednesday, 24 October 2012 10:06 a.m.
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: RPGLE with embeded SQL cursor over file with *READ trigger
On 23 Oct 2012 13:44, Peter Connell wrote:
The restore operation is not pertinent. I did not mention that when
investigating the error I restored the program to a different library
and signed on and off before each test. Executing the program from
either library on the production machine produces the same error.
MCH3601 sent to QSYS/QQQITEMP as an escape msg Pointer not set for
location referenced.
Generic message so explicit details are required to infer well
CPF4204 sent to QSYS/QQQQUERY as an escape msg Internal failure
occurred in query processor.
Generic message for any prior failure of the query
There are 3 machines, DEV, QA and PRD. Compiling from source on each
works.
Strangely restoring from QA to PRD works but restoring from DEV to PRD
produces the SQL error.
Perhaps there's something about the SQL runtime environment on PRD
that is different on DEV and which is connected to the program via the
SQL pre-compiler.
Well normally I would first chide the OP about failing to give the context of the error messages [spooled joblog with header or including at least the release level], and then await that information before replying. But over years I have learned to accept that doing so seems to have nearly as little value as starting a conversation with a wall, so I will just give the most probable answer :-Q
Get the PTF for the OS database query component for which that OS code improperly references a pointer which has not been set in the effectively same scenario\environment. Searching Google for tokens "msgmch3601" "t/QQQITEMP" "read trigger" yielded the APAR SE47793 [with what I consider a corrected symptom kwd string, and with only relevant data:] MSGMCH3601 T/QQQITEMP TM/QQQITEMP TP/ITEMP STMT/10641 SELECT
http://www.ibm.com/support/docview.wss?uid=nas217cff9623c71cf5786257879003c71eb
R710 PTF SI42907 on c1270710
http://www.ibm.com/support/docview.wss?uid=nas3919c6d16fca2d6c5862578aa00635097
--
Regards, Chuck
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
#####################################################################################
This correspondence is for the named person's use only. It may contain confidential
or legally privileged information, or both. No confidentiality or privilege is waived
or lost by any mistransmission. If you receive this correspondence in error, please
immediately delete it from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual sender, except where
the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :-
Australia 1300-762-207 or New Zealand +64 9 367 6200
midrange.com
