To Run a SQL Script Using the Command-line isql Tool

From InterBase
Jump to: navigation, search

You can run a script from any console prompt using the -input option to isql. Specify the full path and filename. In the following example, the script does not contain a CREATE DATABASE statement; it runs against an existing database:

isql database_name -input filename

The following example runs a script that creates a database:

isql -input filename

During an active isql session in which you are already connected to a database, you use the INPUT command to read and execute a SQL script against that database:

SQL> INPUT filename

See Invoking isql for more about running isql.