I want to suggest simple improvement to execute statement - make it
possible to run in it CREATE DATABASE statements. It will not accept
parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ...
TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL which switches to
the context of newly created database in execute statement after
successful creation handle to created database will be immediately
closed. It's supposed that later one can access it using ON EXTERNAL
DATA SOURCE clause of EXECUTE STATEMENT.
In the simplest form (create database on current server) that will look
like this:
execute statement 'create database ''/tmp/t1''';
When one needs to create database on remote server appropriate
credentials may be specified in CREATE DATABASE:
execute statement 'create database ''hostname:/tmp/t2'' user ''sysdba''
password ''masterkey'' ';
or in EXECUTE STATEMENT:
execute statement 'create database ''hostname:/tmp/t3''' as user
'sysdba' password 'masterkey';
Even with mentioned restrictions feature should sooner of all be useful
- with it one can create databases from SP w/o need to use something
like special UDF/UDR for it.
Alex.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
