Re: SP URGENT HELP: SYSTEM .. to keep a log file

"George C Parobek" <george@icc-gcp.demon.co.uk> wrote: :George C Parobek <george@icc-gcp.demon.co.uk> wrote in article :<01bbdc4f$082fd460$7e8a989e@gcp-client>... :> I am using SP for Client Server application. :> In order to monitor and check the update procedures I need to log the :> progress in a unix text file. e.g.: :> :> SYSTEM "echo "||text||" >> log_file"; :> :> This command takes too long top process, cca. 1sec !!!!!! :> :> Is there a better way of achieving the same goal. :> :> Please HELP :> -- :> george@icc-gcp.demon.co.uk :> :I have received two suggestions (many thanks for comunicating): :1. use a DB table as a log file: : - problem with this solution is, that if database crashes or gets :corrupted : there is no trace of update history I am at a loss to understand why you need an update history for a crashed database. You will have to restore it from the backup and logs anyway. At that time the log in the table will be correct for the restored database. The log in a file may not be correct. :2. use trace on function: : - this works OK, but the log file gets overwritten each time the trace : is started. I would have to have a separate log file for each updadte : run and each function. :I am looking for a similar function to that in 4GL errorlog(...) Again something that should not be to hard in Universal Server, although I am not sure of this one. May be it will be possible by using Java in the database instead of todays stored procedures. :Many thanks for the efford and hope to hear more ideas. : Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org