Subject Re: [ib-support] executing SQL scripts on linux clients.
Author Edwin Pratomo
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";