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

On Microsoft Windows platforms you can make Interactive SQL the default editor for .sql files. Thus, you can double-click the file so that its contents appears in the SQL Statements pane of Interactive SQL.

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