I can't remember the syntax or keywords so I'm having trouble searching for it.. can someone remind me of the command(s) that will show the sql that is generated from a table file command? I think it stops the query from being passed to the database as well...
Thanks in advance!

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

Hi,

  
SET TRACEOFF=ALL
SET TRACEON=STMTRACE//CLIENT
SET TRACEON=SQLAGGR//CLIENT
SET TRACEUSER=ON
SET XRETRIEVAL=OFF

The XRETRIEVAL=OFF option will stop database from executing the query.

Best Regards,

Jimmy Pang

Found it searching through a bunch of old code...

SET TRACEOFF = ALL
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEUSER = ON
SET XRETRIEVAL = OFF