Re: rowid

Smitty wrote: > We have 1800+ 4GL programs written using Informix SE 4.0 and have > needed to upgrade for a LONG time. We have a 5-user version of > Informix IDS 7.31.UD5-1 to test with. Someone told us that the newer > versions of Informix don't support "rowid", which is included in a lot > of our code thanks to the FourGen CASE tools. We are having trouble > getting a definitive answer to this question, does anyone know when or > if Informix products stopped using rowid? No they didn't stop using ROWID. Your "someone" is confused. There has been no change to the use of ROWIDs in SE, but in IDS ROWIDs can become duplicated for fragmented tables. For this reason Informix added the option of adding ROWIDS to a fragmented table, which basically adds another column. This column is unique and can be used by legacy code without having to change your code. So, as long as you don't use fragmented tables, or you use fragmented tables WITH ROWIDS, your FourGen code will work unmodified..., well barring fixing any old bugs it may make use of. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+