Re: How do I rename a database?

Path: emory!wupost!darwin.sura.net!haven.umd.edu!ames!data.nas.nasa.gov!sun204.nas.nasa.gov!jcarter From: jcarter@sun204.nas.nasa.gov (John R. Carter Sr.) Newsgroups: comp.databases.informix Keywords: database, rename Message-ID: <1992Mar6.033543.6688@nas.nasa.gov> Date: 6 Mar 92 03:35:43 GMT References: <1992Mar5.213646.14124@cs.odu.edu> Sender: news@nas.nasa.gov Reply-To: jcarter@sun204.nas.nasa.gov (John R. Carter Sr.) Organization: Numerical Aerodynamic Simulation Facility NASA In article <1992Mar5.213646.14124@cs.odu.edu> bander@oswine.cs.odu.edu Writes: > can I rename a database? I really don't think so. The workaround you describe is pretty much what I think has to be done. I've looked into this before and gave up on it. I have two databases - one for testing and one for production. I found this necessary for two reasons: 1) you don't want to be testing on your production database and 2) the DATABASE statement doesn't allow for variables. To help me get around a lot of coding changes there is only ONE file that has the DATABASE statement in it - globals.4gl. And of course, all the screen forms have it as well (there's no getting around that). Even at that, I have established a rather complex method of changing which database I can work on through setting environment variables with simple aliases. Switching back and forth isn't a problem; remembering which one I'm in can be at times. I hope someone else has a really nifty solution for you. ------------------------------------------------------------------------------ John R. Carter, Sr. Programmer/Analyst - Informix DBA Computer Sciences Corporation jcarter@nas.nasa.gov Numerical Aerodynamic Simulation 415/604-3662 NASA Ames Research Center, Moffett Field, CA 94035-1000 M/S 258-6 ------------------------------------------------------------------------------