Path: utzoo!attcan!uunet!seismo!sundc!pitstop!sun!decwrl!labrea!rutgers!mailrus!ukma!cwjcc!hal!ncoast!allbery From: allbery@ncoast.UUCP (Brandon S. Allbery) Newsgroups: comp.databases Subject: Re: Unify DB Audit Trail? Message-ID: <13235@ncoast.UUCP> Date: 10 Dec 88 18:03:31 GMT References: <7222@charlie.OZ> <560@4gl.UUCP> Reply-To: allbery@ncoast.UUCP (Brandon S. Allbery) Followup-To: comp.databases Organization: Cleveland Public Access UN*X, Cleveland, Oh Lines: 29 As quoted from <560@4gl.UUCP> by honzo@4gl.UUCP (Honzo Svasek): +--------------- | From article <7222@charlie.OZ>, by root@charlie.OZ (Just call me SUPER): | > We are developing a Unify/Accell based application for the | > payroll system here at the University. A requirement of this | > system is to provide audit trail facilities for data entry, | > internal auditor's, etc.. Has anyone any experience in this | > area to offer suggestions/solutions. | | We have developed a utility that reads the Unify transactie log file | and converts it into ASCII. As it also translates the 'field numbers' | into field names, so it is not effected by database configurations. | | The only problem is that it is a commercial product and I cannot post it. | A source licence is not that expensive though, please mail me for more info. +--------------- May I suggest that this is rather trivial, given the information in the RDBMS HLI manual (the blue one, if they use the same color conventions everywhere)? Check the chapter on transaction logging and the function reference for opentj() et alia. ++Brandon -- Brandon S. Allbery, comp.sources.misc moderator and one admin of ncoast PA UN*X uunet!hal.cwru.edu!ncoast!allbery ncoast!allbery@hal.cwru.edu allberyb@skybridge.sdi.cwru.edu allbery@uunet.uu.net comp.sources.misc is moving off ncoast -- please do NOT send submissions direct Send comp.sources.misc submissions to comp-sources-misc@.