Re: CRCOLS and VERCOLS and REPLCHECK

Why choose, you can have all three: > create table has_it_all(one serial) with crcols with replcheck withvercols; Table created. ER needs CRCOLs for normal processing and conflict resolution. It can use the replcheck columns to speed synchronizing servers. Any and all can be used by application programs to implement optimistic locking protocols better and more cheaply. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Wed, Apr 21, 2010 at 12:18 PM, Laurie Gustin <lgustin@utah.gov> wrote: > IDS 115FC6X3 > > > I am setting up a system that will use both SDS servers and ER. I > understand that CRCOLS and REPLCHECK columns are used for ER and VERCOLS > are mainly for SDS servers... but it doesnt appear that you can add all 3 > (or even 2) sets of these columns to a single table. Can anyone give me > guidance on which set of columns would be best... if ER must have CRCOLS... > then are there any options for using the other two? > > Thanks > > Laurie > > > Laurie Gustin > IT Programmer Analyst > Department of Public Safety > lgustin@utah.gov > 801-965-4410 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >