Re: alter table wipes out systables.dirpath - SE5.0

>>The only workaround is to find out >>the filename of the ISAM files (.dat and .idx) and move them to the >>directory where you want them and update dirpath in systables manually. What I noticed was that new database files were created in the right place (i.e. original directory) but dirpath was initialized. When I called support, he said, Informix will not support the database if we modify any systables columns. According to him, Informix will only guarantee a correct execution of the DDL statements if all the database file resides in .dbs directory. I took his word and I said fine. I will do the work around. But later I realized that, CREATE TABLE statement has got IN clause, using which you can specify location of the database files. Which you do that without explicitly touching systables table. I left a voice mail for him. Let's see what he says! Sadru Fidai