April 22, 2005, 01:57 PM
secretHow do you view Focus Generated SQL?
In old FOCUS you could allocate fstrace. Is there an equiilaant method in WEBFOCUS?
April 22, 2005, 02:33 PM
<JG>If you have access to the webconsole and admin privileges then you can turn on the tracing dynamically there. When viewing the traces you can filter them so that you can just look at the SQl.
April 22, 2005, 03:15 PM
RBThese commands would help view the SQL in view source.
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEUSER = ON
April 22, 2005, 03:50 PM
dwfTry this:
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACEUSER = ON
Then View Source after your run
April 22, 2005, 03:59 PM
<JG>add
SET XRETRIEVAL=OFF
It will generate the SQL without actually running the request and the SQL will come directly back to the browser.