How to generate SQL trace on WebFOCUS
Article ID: KB0070670
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | WebFOCUS version 82 to 92x |
Description
How to generate SQL trace on WebFOCUS
Issue/Introduction
How to generate SQL trace on WebFOCUS
Resolution
By adding the following statements at the top of the focus code. The SQL queries will show up on the screen.
SET TRACEOFF=ALL
SET TRACEON=STMTRACE//CLIENT
SET TRACEON=SQLAGGR//CLIENT
SET TRACESTAMP=OFF
SET TRACEUSER=CLIENT
SET XRETRIEVAL=OFF
-RUN
You can view the information in the WebFOCUS Client and then take the procedures listed below to run the FEX with SQL Trace.
1. Logon the WebFOCUS client and navigate to the workspaces
2. Right-click on the fex which you want to see the SQL trace then navigate Run >> Run with SQL trace.
3. It will display the output with SQL Traces.
Attached video for reference.
Attachments
Feedback
Yes
No
Powered by
