Re: time consistant view

Thanks, this seems to work "scottishpoet" <dryburghj@yahoo.com> schreef in bericht news:1132229696.669169.116400@f14g2000cwb.googlegroups.com... > to ensure you don't miss any rows or have any duplicates you need to > lock both the lock the tables in exclusive mode before you do the > select > > you may also want to consider > > select * from history where date >=("17/11/05") > union > select * from planned where date >=("17/11/05")> > but I am not sure if a row is moved from history top planned wheile > this select is running that you could guaranetee you didn't miss it > > > > ECS wrote: >> Hi, >> >> informix 7.31fc6 >> Using Informix Enterprise Command Center SQL Editor 3.01.TC1 >> I want to query 2 tables, a history table and a planned table. >> select * from history where date >= ("17/11/2005"); >> select * from planned where date >= ("17/11/2005");>> >> Both selects take 5 minutes. >> The application is continuously running, moving entries from planned to >> history. >> How to make sure that I don't miss any entries, or have some doubles? >> >> TIA, >> >> Daniel >