Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.