Re: Renaming a database

(Sorry to send this out to *everyone*, but I cannot reach him directly) Jim Bander bander@cs.odu.edu writes: > :: > Therefore, my question: can I rename a database? If there were a way, > then I could write shell scripts that worked as follows... > :: To rename a database, you simply rename the *.dbs directory. For example, to rename the "test" database to "production" database, you use: mv test.dbs production.dbs Informix does *not* internally store the database name anywhere in the system tables, it just uses the Unix/DOS directory name. Caveats: This works with our version of Informix (2.10); it may be different for 4.0-5.0. Also, if you want your existing 4gl programs to reference the *original* data, you must recompile the programs with the new database name. Todd Glidden doimic01@saad-emh1.army.mil "My employers don't pay me enough to come up with amusing sayings"