Executing Command Files

There are three ways to execute command files.

  • Use the Interactive SQL read command to execute command files. this statement executes the file temp.sql:
    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 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, 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.