I am trying to save the messages generated in html when we run a fex program to a log or text file. Can any one please let me know how to do that
thanks

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

Look into adding SQL trace commands to your fexes.

-SET &ECHO = ALL; lets you see the messages/output of running your fexes in browser below the output. Sometimes you have to view source to see it.

These are the command I use for SQL tracing:

-*** Set up SQL tracing

-*** Deactivate SQL tracing
SET TRACEOFF = ALL

-*** Show Commands and data exchange between the physical and
-*** the logical layers of the data adapter
-*SET TRACEON = SQLCALL

-*** Enable Trace for the SQL Translator
SET TRACEON = SQLTRANS

-*** Show SQL statements
SET TRACEON = STMTRACE//CLIENT

-*** Show Optimization information
SET TRACEON = SQLAGGR//CLIENT

-*** Show SQL generated statement trace
-*SET TRACEON = STMTRACE/1/CLIENT

-*** Show SQL generated sub-statement trace
-*SET TRACEON = STMTRACE/2/CLIENT

-*** Disable the trace stamp (Date/Time etc)
SET TRACESTAMP = OFF

-*** Set trace line wrapping - # of characters
SET TRACEWRAP = 78

-*** Set trace to output file
-*SET TRACEUSER=C:\ibi\apps\baseapp\sql_trace.txt

-*** Activate SQL tracing
SET TRACEUSER = ON

-RUN

Uncomment -*SET TRACEUSER=C:\ibi\apps\baseapp\sql_trace.txt to put the SQL trace in a file. You can name the file whatever you want, including adding the userid, date/time in the file name to make it unique to each execution.