There are three ways to execute command files.
Using the Interactive SQL read command to execute command files. this statement executes the file temp.sql:
read temp.SQL
Loading a command file into the SQL Statements pane and execute it directly from there.
You load command files back into the SQL Statements pane by choosing File | Open. Enter transfer.sql when prompted for the file name.
The SQL Statements pane in Interactive SQL has a limit of 500 lines. For command files larger than this, you should use a generic editor capable of handling large files and use the read command to import it into Interactive SQL, which has no limit on the number of lines it can read.
Supplying a command file as a command-line argument for Interactive SQL.
