Hi all,

I have a Baan query with a report script.
Is there any way to retrieve the select statement as it is used by the Baan-Oracle driver without having to run the query with a trace ?
We may have to convert some Baan queries to Oracle statements.

kind regards,

Walter

Not sure but your Oracle Admins should have something that could trap it. I just know that our Oracle admins have done this at times to see if the indexes baan is using are good or if they could improve them.

Also check out this performance tuning and tracing guide (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7665). It may have what you are looking for.

Mark

If you are referring to the SQL query in Baan, Click on the Text Manager
button on your Query and that should show you the actual query.

If that is not it and if you are referring to the Report script, thats again a click view/edit script as the case may be.
Good luck