RE: Can I create a non-logged perm. table in a logged DB?

Kyle Campbell wrote: > I have Informix ODS 7.2. I'd like to be able to keep rows > inserted into a permanent table even if the 'insert' is in an active > transaction that was rolled back. The reason for this is that I'd like > to log atomic actions performed in a complex stored procedure to my own > log table, but if I need to rollback work performed in the stored > procedure I still want to keep the rows inserted into my 'log' table. > Too bad Informix doesn't have the ability to print to a file from > a stored procedure and the 'SYSTEM' call is too expensive to use > extensively. Does anyone have any tips? > > Thanks, > Kyle > I agree that SYSTEM is way too expensive. SET DEBUG FILE TO ... WITH = APPEND and a subsequent TRACE call should be less so. (It's really only = opening a "w+" filehandle). I would give it a try and see what the = performance is like. cheers RET +------------------------------------------+ | Richard Thomas | | DBA - Marketing Information Systems | | Optus Communications | | email: richard_thomas@yes.optus.com.au | | Ph: +61 2 9342 7188 | | "My opinions are my opinions" | +------------------------------------------+