Re: Reporting on audit trails (SE)
Posted in 1994
Hugh Grierson — — source: Informix-list mailing list archive (1991-1998)
In article <1994Jun1.020233.12277@nezsdc.icl.co.nz> I write: >I need to access the data written to an audit trail from SE. Using SQL >is preferred, but I can't find the notes I once had on exactly how to >do it. ... >What am I missing? Thanks to Jonathan Leffler for the solution. If I create an index on the audit table before doing the REPAIR TABLE or bcheck, (either before or after copying into the dat file, it doesn't seem to matter) then it all works as planned. IE: * create the audit table * copy over the .dat file * create an index * repair the table * select from the table Cheers, -- Hugh Grierson hugh@fujitsu.co.nz 16C, clear, cool southerlies