At 08:13 AM 7/12/2004 +0000, you wrote:

>Hi,
>
>I have written a Java-Application accessing a Firebird 1.5.1
>database. For some reasons I need to create a temporary database and
>later drop it. The temporary database is created by calling the
>command-line tool "gbak". Now, how do I drop the (remote) database?
>Do I need to call isql? Or is there a more elegant way, e.g. a SQL
>statement?

Both. There is an SQL statement DROP DATABASE that is only available in
isql. Write a script like the one below and invoke isql from the command
line to process it:

Script MyScript.SQL:

SET AUTODDL ON;
CONNECT 'MyServer:MyAlias
USER 'sysdba' PASSWORD 'mystarke';
DROP DATABASE;
[ include a carriage return here ]

Save this script, then invoke it somehow like this:

/opt/firebird/bin/isql -input /appdata/MyScript.SQL

./hb