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

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.