Re: Migration v5.0 to v7.10
Posted in 1995
>> The application uses rowids in v5.0 so I will need to get hold of the
>> rowid work around for v7.1.
>> [...sig deleted...]
>
>The workaround is to either create your own column called "rowid" or to
>use some other key.
There is also a "WITH ROWIDS" option in the FRAGMENT BY part of the
CREATE TABLE statement. Remember, rowid in 7.1 is only a problem on fragmentedtables. For most on-line transaction processing applications, you will
not be fragmenting tables. Table fragmentation is primarily a feature
for decision support and data warehousing.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Randall Rhea Systems Engineer
Informix Software randall@informix.com