Hi All

I know that I can show SQL with

SET TRACEUSER = ON
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT


HTML output and then view source and I see the SQL...

but here is my question.... how can I capture the SQL and display it nicely in a page myself. I mean is there a way to save the SQL somewhere in APP PATH or anywhere else... and then TABLE FILE it so I can display it nicely in a footer underneath the report? Is it in a trc file somewhere that I can read?

Thanks and Happy Holidays!

Jodye

This message has been edited. Last edited by: jodye,

See this post for the method to write the SQL trace to a file. Then you can create a master to read it.

http://forums.informationbuild...171047192#7171047192

Hi Dan

That is exactly what I wound up doing. Works like a charm.

Thanks

Jodye