Re: Reducing size of .dat and .idx in SE5.02

: spitz@GANS2X.ana.med.uni-muenchen.de (Richard Spitz) writes: : Jonathan Leffler (johnl@informix.com) wrote: : : When you do either an ALTER TABLE or an ALTER INDEX which is not a no-op, : : then the table is rebuilt in a new file, and it is assigned a new Tabid in : : SysTables. ^^^^^^^^^^^^^^^^^^^^^^^^^^ : : Is there a way to make sure that the rebuilt table has the same tabid _AND_ : (even more important) filename as the original table? : : We need that because we have a database which is used by C-ISAM and SE : concurrently. The table filenames are hardcoded into the C-ISAM app, : so the rebuild of the table must not change that. : : Is it safe to rename the new file back to its old name and change : systables accordingly? I'm rather hesitant to fiddle with tablenames. Why don't you put your C-Isam tables in one directory, the SE-database tables in another and create links between them. In that case all you need to do when you rebuild a table in the SE-database is to recreate the link to the appropriate file in your C-Isam directory. Nils.Myklebust@ccmail.telemax.no NM-data AS, Toyenbekken 21, Oslo, Norway My opinions are those of my company