Focal Point
Can WF Display the SQL used?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5521013341

December 13, 2005, 04:00 PM
Dan Morphis
Can WF Display the SQL used?
I'm trying to figure out where a cartesian is in my FEX / Master Files. In my report, is it possible for WF to display the SQL it used?

Thanks,
Dan


Test: XP / WF 7.1.1
December 13, 2005, 04:27 PM
Francis Mariani
Yes, you can have the SQL displayed.

This is what I include before any request (TABLE FILE, GRAPH FILE) that accesses a DBMS:

SET TRACEOFF = ALL
SET TRACEON = SQLTRANS
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACESTAMP = OFF
SET TRACEWRAP = 78
SET TRACEUSER = ON
-RUN

You can also add

SET XRETRIEVAL = OFF
-RUN

just before the TABLE/GRAPH command to preview the request without actually accessing any data.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server