December 13, 2005, 04:00 PM
Dan MorphisCan 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
December 13, 2005, 04:27 PM
Francis MarianiYes, 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