>I am trying to test the performance of a system and so I would like to list all the non optimised queries. However the sys(3054) function only output to the active window, I need the information to be piped to a file? Does anyone know how to do this or is there an alternative method?
You could
SYS(3054,1)
SET CONSOLE OFF
SET ALTE TO xyz.txt
SET ALTE ON
*-- Run SQL
SET ALTE OFF
SET CONSOLE ON
*-- Do non-SQL STUFF
and so on. At the end of the code:
SET ALTE OFF
SET ALTE TO
MODI COMM xyz.txt
BTW, you can get even MORE information from SYS(3054) if you pass 11 as the parameter!
SYS(3054,11)