How to export event log using sql option quicker ?
Hi Team,
How to extract/export the event logs quicker from Ens_Util.Log (intersystems log) using query itself.
(Similar to OUTFILE in sql)
Discussion (1)2
Comments
Not sure what version of Caché or IRIS you're on; for future reference it's helpful to include that information. In IRIS 2021.2, you can do this from the IRIS SQL Shell:
JEFF>do$system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
The command prefix is currently set to: <<nothing>>.
Enter <command>, 'q' to quit, '?' for help.
[SQL]JEFF>>set displaypath /home/jeff/tmp/
displaypath = /home/jeff/tmp/
[SQL]JEFF>>set displayfile sqlout
displayfile = sqlout
[SQL]JEFF>>set displaymode csv
displaymode = csv
[SQL]JEFF>>set selectmode display
selectmode = display
[SQL]JEFF>>select top 100 * from Ens_Util.Log
13. select top 100 * from Ens_Util.Log
/home/jeff/tmp/sqlout.csv
/home/jeff/tmp/sqloutMessages.txt
statement prepare time(s)/globals/cmds/disk: 0.0002s/6/831/0ms
execute time(s)/globals/cmds/disk: 0.0035s/467/20822/0ms
cached query class: %sqlcq.JEFF.cls115
---------------------------------------------------------------------------
The default delimiter is comma, but you can change that. For example, the tab character:
[SQL]JEFF>>set displaydelimiter = $C(9)