sibusiso xolo wrote:

>
> Greetings,
>
> I would like to know the procedure for executing SQL scripts in isql. I am
> using linux.
>
> I can envisage a way to use the edit command from isql to open an editor
> (such as vi) then load the prepared sql file then save it (it goes in
> /tmp) and on quitting the script will execute.
>
> However what I would like to know IS if there is another way using Load
> Script or Execute Script (as with IBConsole) from the isql comand prompt?

ibsql -i yourscript.sql

yourscript.sql must contains connect string at the top of it.

For example:

CONNECT "/opt/interbase/data/foo.gdb" USER "sysdba" PASSWORD "masterke";
DROP DATABASE;

--
rgds,
Edwin