Re: sperform & tables in more than one dbspaces

Could you consider keeping rowids by using the "add rowids" clause? From TOOLEREL docs: However, the 7.X INFORMIX-OnLine Dynamic Server provides a method for making fragmented tables which are usable with ISQL, using the WITH ROWIDS option. If the user or DBA creates all affected tables using the CREATE TABLE or ALTER TABLE statement with the ADD ROWIDS option, the server will add an artificial ROWID column to that table. The addition of this column will allow ISQL to work with fragmented tables. Sally Woolrich wrote: > > > We have discovered that we cannot use sperform on tables in more than > one dbspace (as opposed to tables in a single dbspace with more than > one chunk). > > Informix is 7.30, tools are 7.x. > > Of course it's because ROWID is no longer available to us. :-( > > Is there another utility, or later version of speform, which overcomes > this problem? It's so handy to be able to whip up a quick form, and > of course the tables we've had to fragment in this way are key tables > in our database! > > TIA > > > -- Colin McGrath cmm@trac3000.ueci.com Washington Group International, Inc. (215) 422-4144 Philadelphia, PA, USA Any opinions I state are my own and not necessarily those of my employer