There are three ways to execute command files.
read temp.SQL
Load 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
. 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, 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.
Supply a command file as a command-line argument for Interactive SQL.