-* Can be compact in a single line: 
-* SET MESSAGE=OFF,TRACEOFF=ALL,TRACEON=STMTRACE//CLIENT,TRACEUSER=ON,TRACESTAMP=OFF  

-* Much of this doc for TRACEON was take from Focal Point posts.
-* SET XRETRIEVAL = OFF                 Used stop retrieval any data from the database. This is good to use for diagnosing long running sql queries.   
-* SET MESSAGE    = OFF                 Shows the sql trace code without having to click on the Blue "No Data" link.       
-* SET TRACEOFF   = ALL                 Deactivates SQL tracing.       
-* SET TRACEON    = SQLCALL             Show commands and data exchange between the physical and the logical layers of the data adapter. 
-*                  SQLTRANS            Enable Trace for the SQL translator.  
-*                  STMTRACE//CLIENT    Show SQL statements.  
-*                  SQLAGGR//CLIENT     Show optimization information.  
-*                  STMTRACE/1/CLIENT   Show SQL generated statement trace. 
-*                  STMTRACE/2/CLIENT   Show SQL generated sub-statement trace. 
-* SET TRACESTAMP = OFF                 Disable the trace stamp (Date/Time etc.). 
-* SET TRACEWRAP  = 100                 Set trace line wrapping to # of characters. 
-* SET TRACEUSER  = ON                  Activate SQL tracing. 
           
 SET XRETRIEVAL = OFF 
 SET MESSAGE    = OFF                 
 SET TRACEOFF   = ALL                
 SET TRACEON    = STMTRACE//CLIENT   
 SET TRACEON    = SQLAGGR//CLIENT    
 SET TRACESTAMP = OFF                
 SET TRACEWRAP  = 100                
 SET TRACEUSER  = ON                 
  
 TABLE FILE masterfile
 COUNT *
 END