Luis,
The program currently prints SQLCODE on the error report and has an option to do a program dump at that point,
and I checked and CPA4259 is not on our system reply list and these jobs (several for each person running "Dispatch")
are not set INQMSGRPY(*SYSRPYL).
Because key values also show on the error report, I don't yet see value in a program dump so please let me know if I'm mistaken.
I'll need to check on SQLWRN, but I'm working on an un-related program change so I'll get that done by early next week.
Thank you for help!
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Friday, July 17, 2015 1:11 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Unexpected SQLSTATE returned from embedded SQL
On Fri, Jul 17, 2015 at 1:02 PM, Gary Thompson <gthompson@xxxxxxxxxxx>
wrote:
...CPA4259/QUERY_TIME_LIMIT, but we did not see that during a check
yesterday where we compared the report showing SQL 02000 and the job's
log covering that time.
I checked WRKRPYLE and don't see an entry there.
From what I see that message would tend to put the affected job in
message wait ?...
Gary,
Yes, AFAIK CPA4259 would have show as an error message in your job's log (unless, of course, its reply list had been modified (CHGRPYLE)) .
Can you modify your program in order to show the values for SQLCODE and SQLWRN? Better yet, try a program dump when you have an unexpected SQL0200 message.
Regards,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.
midrange.com
