unload creating duplicate versions of edited records

Hi, We have a 4GL program that extracts data from a table using an unload. If it encounters a record that is been edited it then creates 2 versions of this record, one pre-edit and one post edit. We don't need a particular version of the record, as long as we only get one version. I have never heard nor seen this behaviour before and am at a loss as to what causes it and how to solve the problem. Thanks for any suggestions. We are using 4GL 7.31.FC1, Informix Dynamic Server 7.31.UD3 on Solaris 8.

The program has probably set DIRTY READ ISOLATION. You want COMMITTED READ or CURSOR STABILITY isolation and to SET LOCK MODE TO WAIT <nseconds> to avoid getting lockout errors from brief transient locks. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 19, 2009 at 8:51 PM, Bones <wayne@barebonesphoto.com> wrote: > Hi, > > We have a 4GL program that extracts data from a table using an > unload. If it encounters a record that is been edited it then creates > 2 versions of this record, one pre-edit and one post edit. We don't > need a particular version of the record, as long as we only get one > version. > > I have never heard nor seen this behaviour before and am at a loss as > to what causes it and how to solve the problem. > > Thanks for any suggestions. > > We are using 4GL 7.31.FC1, Informix Dynamic Server 7.31.UD3 on Solaris > 8. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >