Re: Help ?? : 4GL Informix 6.0 Porting Problem

At 11:34 AM 7/12/95 +0000, james@bi-tech.com wrote: >On Wed, 12 July, Jon C. Vemo wrote: > >> Also, If you have implemented fragmentation/partitioning, you will >> NOT be able to relyably use ROWID in your programs. RTFM on the >> 7.1 server product for more information re: the use of ROWID. >> > >My understanding is that 7.1 has this SQL statement for fragmented >tables: > >ALTER TABLE gorp ADD ROWIDS> >I don't have 7.1 loaded, so I'm not sure if this _really_ works or >not. James - Yes the alter statement does work, but what it actually does is add a serial, indexed column to your table schema. This allowes applications which use ROWID to continue to work unmodified. However this is essentially the same as using a primary key for access, so why not use primary key, and eliminate the overhead of an additional indexed integer type column?? (I understand, that a unique primary key may not be included in every table, so adding the ROWID column or some other unque column, would be necessary. Jon > ================================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ------------------------------------------------------------------ Watch out for road-kill on the information superhighway....SPLAT!! ==================================================================