Re: SE and SQLCA question

Bryan Tonnet wrote: > > Is it not also the case that V7.X does not maintain unique rowids across > dbspaces? I dont use this rev yet so I dont know for sure, but I think > I've seen a thread here that mentioned it..... This is if you use fragmentation. Each fragment is effectivly a separate table space on a different chunk in a different dbspace. So it IS possible to get duplicate rowid's. > To wit, use of the rowid as a unique record identiifer would have to be > done cautiously. Would it not be better to manually include a serial > as a primary key on each table? Yes it would. I believe this is the recommendation from Informix. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+