time consistant view

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

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