Linking SELECT statement back to aplication

Getns,

The problem I am working on is long running queries. I have to figure out what application have issued that query.

SELECT clause column list is driven by grid column information. But engine sticks some extra fields in it!

Does anyone know why? One valid reason I found is "Auto Include" Data Dictionary parameter. But not all extra fields have it.

Any thoughts will be appreciated,

Thanks!
Adil

hi,
the primary key fields seem to be automatically included as well.

You may be seeing fields that are added by JDE security - especially row security.

Very good guess!

But we do not have any security on DMCS, EDLN, EMCU, PRP1, PTC extra fields in query text? There is nothing special about them...

Very good guess too!

But DMCS, EDLN, EMCU, PRP1, PTC extra fields in query text not part of any PK's or FK's. There is nothing special about them...

Hi Adil,

If you can attach the logs then that might help in finding the cause.