You can execute command files by:
Using the Interactive SQL read command to execute command files. The following 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.
Supplying a command file as a command-line argument for Interactive SQL.
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.
