Re: Renaming database on IDS 7.30

Mark Oberfield wrote: > > Hi, > > I am reasonably confident of the answer but I want to confirm it with > the sages in this newsgroup. > > Is there a way to change the name of a database without having to > export it, twiddle the schema file, and then re-create it with the new > name? > > My pointy-haired boss has suggested that I change the name in the > sysdatabases table. I don't think that is a good idea but I don't > have the luxury of having an "offline" IDS 7.30 server to corrupt or > experiment with. Get that boss a hair sharpener! NEVER NEVER NEVER, did I say NEVER yet? INSERT UPDATE OR DELETE from any tables in SYSMASTER. In the words of the Informix Manuals and many folk I know in Menlo the results are "UNKNOWN" read that "You may trash your a**!" Don't do it. Of course there is the obvious SQL command: RENAME DATABASE oldname TO newname; Now this is completely safe. Keep the SQL Quick Syntax Guide handy. Art S. Kagel