Command files are text files that contain SQL statements
and are useful if you want to run the same SQL statements repeatedly.
You can use Interactive SQL to open, view, run, and save command
files.
Execute the command file using one of these
methods:- Use the Interactive SQL READ statement
to execute command files.
For example:
READ temp.sql;
- Load a command file into the SQL Statements pane
and execute it directly from there.
- Load command files into the SQL Statements pane
by choosing . Enter the file name when prompted.
- Run a command file without loading it by choosing
.
- Supply a command file as a command line argument
for Interactive SQL.