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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Can't say I've used STRDBMON in recent years, but IIRC it's the same
monitor as what's started from ACS SQL Performance Center..

The ACS tool even allows you to compare two different monitors.

Lastly, you can run analysis and show statements from each monitor and dig
into the statements with VE.

Given the behavior you describe, I suspect the RPG program isn't opening
the same tables you're accessing from ACS.

Charles

On Thu, Nov 2, 2023 at 2:21 PM Martijn van Breden <
m.vanbreden@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Hi Charles
>
> Thank you for your reply . I would say exactly the same. It shouldn't
> matter whether you execute a statement in a RPG program or via ACS although
> I ran into a problem before which turned out to be caused by a storage
> model difference between ACS and my application environment.
>
> The fact of the matter right now is that is does make a difference for me
> and that the application is wrong... I really doubt that there is a copy
> difference, I checked it over and over again with a colleague and most of
> the variables are introduced via host variables which I also checked and
> double checked.
>
> To me that leaves the option of differences in query settings. I looked to
> STRDBMON and got it to work and monitored both queries. The outcome was a
> bunch of mostly undescribed columns in a file which indeed showed
> differences, but even uncle Google wouldn't explain me what these columns
> were actually about.