Using SQL command files

This section describes how to process files consisting of a set of commands. Command files are text files that contain SQL statements, and are useful if you want to run the same SQL statements repeatedly.

Creating command files

You can use any text editor that you like to create command files. You can include comment lines along with the SQL statements to be executed. Command files are also commonly called scripts. See Comments.

Opening SQL command files in Interactive SQL

You can make Interactive SQL the default editor for .sql files on a Windows operating system. When you double-click the file, the file contents appear in the SQL Statements pane of Interactive SQL.

For more information, see Setting Interactive SQL as the default editor for .sql files.


Run SQL command files in Interactive SQL
Writing database output to a file