Re: Different result from full outer join in ACS RunSqlScript and SQLRPGLE

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> namens Charles Wilt

<charles.wilt@xxxxxxxxx>

Now having said that, I'll say the above is true 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