Re: Fw: Fw: Company thought DB2 will be better than Oracle.

Mark Denham wrote: >>Flashback Query >> >> >You mean the system forgets what it was doing and has to be reminded? I'm >impressed. I thought it was only humans that suffered Altzeimers. > Try this in informix. TRUNCATE TABLE <table_name>; or DELETE FROM <table_name>; COMMIT; If you can then recover all of the records that were in the table to a previous transaction point or point-in-time within a few minutes without running for the backup tapes you don't need flashback. Otherwise ... you might just find it handy. >Great!!! When are they going to get any of them working on anything more >complex than a slide projector? > You really should take my class at the University of Washington. We do it real-time for every class, I don't allow slide projectors or PowerPoint in my classroom. And each and every student does it on their own machine. It is really rather elementary to do and extraordinarily powerful. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)