Tim,

Should 'ALTER TABLE DbName IN MEMORY' copy the catalog of DbName to
memory, or not? I'm not sure I understood the expected functionality of
ALTER DATABASE...

--
Fernando Dias
Easygate, Lda

Fernando,

<< Should 'ALTER TABLE DbName IN MEMORY' copy the catalog of DbName to
memory, or not? >>

No.  ALTER DATABASE simply changes the information about the database in the
configuration file.  It does not affect the target database contents at all.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> No.  ALTER DATABASE simply changes the information about the database in the
> configuration file.  It does not affect the target database contents at all.

But ALTER DATABASE DbName PATH <NewPath> copies the catalog to
<NewPath>, (if there is no database at <NewPath>)...

Also:
1. Can we change the description without indicating the PATH parameter?
2. How to change the catalog to "not encrypted" with ALTER DATABASE ?

--
Fernando Dias
Easygate, Lda

Fernando,

<< 1. Can we change the description without indicating the PATH parameter?
>>

No, you have to specify everything that defines the database.

<< 2. How to change the catalog to "not encrypted" with ALTER DATABASE ? >>

Just leave off the ENCRYPTED CATALOG clause.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

About the catalog copy on ALTER DATABASE, I'm testing this again with
EDB Manager, and sometimes it copied the catalog others it did't - just
created an empty catalog -  I couldn't yet understand under what
circumstances the catalog is copied. It seems there is something I'm
missing...

> << 1. Can we change the description without indicating the PATH parameter?
>  >>
>
> No, you have to specify everything that defines the database.

Not very practical...
It would be great if you could change this in a future release.
Isn't the name enough to indicate what database we want to ALTER?

--
Fernando Dias
Easygate, Lda

Fernando,

<< About the catalog copy on ALTER DATABASE, I'm testing this again with EDB
Manager, and sometimes it copied the catalog others it did't - just created
an empty catalog -  I couldn't yet understand under what circumstances the
catalog is copied. It seems there is something I'm missing... >>

No worry.  I'll find out the reason and make sure that it is fixed before
the week is out.

<< Not very practical... >>

Yes, but necessary.  It's the only way to allow for *not* specifying certain
options without resorting to coming up with a whole new set of clauses to
turn certain properties off, such as the ENCRYPTED CATALOG clause.

--
Tim Young
Elevate Software
www.elevatesoft.com