× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Charles


Check my post, it has PTFs for 7.3, 7.4, and 7.5 - Martijn had provided the 7.4 there, as well as the APAR.


RegardsVern


On Wed, 22 Nov, 2023 at 8:39 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:


To: rpg programming on ibm i

I did say it was possible, and to contact IBM with your traces and
monitors. :)

What was the PTF/APAR?

Charles

On Tue, Nov 21, 2023 at 11:49 PM Martijn van Breden <
m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx<mailto:m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx>> wrote:

Hi all,

Just an update on this issue to keep you informed.

As some of you already mentioned it's highly unlikely that the query
engine returns different results when exactly the same query is invoked
from different environments. Like in my case, from within SQLRPGLE or from
ACS-RSS.

Highly unlikely, but not impossible. I ran tests for IBM support and
uploaded a bunch of traces, monitors and so on. The query implementation on
the background was the same, but the results weren't. We were adviced to
install a PTF (whilst running on 7.4 TR7) which solved the problem.

So what I've learned from this. I've you're convinced that you see what
you see, but still can't believe that you see what you see, fly in an extra
pair of eyes...


________________________________
Van: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>> namens Charles Wilt
<charles.wilt@xxxxxxxxx<mailto:charles.wilt@xxxxxxxxx>>

Now having said that, I'll say the above is true 99.99999<http://99.99999>% of the time.

The other 0.00001%, a bug in the OS causes the difference in run-time
environments to surface different results.

Note this isn't RPG vs ACS, it's just that the defaults settings *FIRSTIO
vs. *ALLIO, memory available to the QZDASOINIT job vs. interactive...ect.
If you configure the environments the same, you'd get the same
right/wrong
answer from each tool.

If you run a DB monitor and capture each invocation, you might be able to
tell where the statement is different.

Or you've got something to hand to IBM and ask them what is going on.

HTH,
Charles



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.