It seems odd that I can't change the database directory for an existing
database. I may want to copy the database to another drive (because I
ran out of disk space) but the EDBMgr forces me to drop the old database
and create a new database. Wouldn't it be easier if I could just edit
the database property and modify the database directory?

Dave

Dave,

<< It seems odd that I can't change the database directory for an existing
database. I may want to copy the database to another drive (because I ran
out of disk space) but the EDBMgr forces me to drop the old database and
create a new database. Wouldn't it be easier if I could just edit the
database property and modify the database directory? >>

1.06 will have expanded ALTER capabilities for all ALTER statements,
including the ALTER DATABASE statement.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> Dave,
>
> << It seems odd that I can't change the database directory for an existing
> database. I may want to copy the database to another drive (because I ran
> out of disk space) but the EDBMgr forces me to drop the old database and
> create a new database. Wouldn't it be easier if I could just edit the
> database property and modify the database directory? >>
>
> 1.06 will have expanded ALTER capabilities for all ALTER statements,
> including the ALTER DATABASE statement.
>

Ok good. How about adding an "if exists" for:

drop table if exists tablex;
?

I have sql scripts that depend on this and I don't have an SQL-only
workaround.

Dave

Dave,

<< Ok good. How about adding an "if exists" for:

drop table if exists tablex;
?

I have sql scripts that depend on this and I don't have an SQL-only
workaround. >>

You'll have to see how the new scripts in 1.06 work.  With conditional IF
processing, you really don't need an IF EXISTS clause anymore.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Dave,
>
> << Ok good. How about adding an "if exists" for:
>
>  drop table if exists tablex;
>  ?
>
>  I have sql scripts that depend on this and I don't have an SQL-only
> workaround. >>
>
> You'll have to see how the new scripts in 1.06 work.  With conditional IF
> processing, you really don't need an IF EXISTS clause anymore.
>

Ok, great.

Dave