Command files are text files that contain SQL statements, and are useful if you want to run the same SQL statements repeatedly. You can use Interactive SQL to open, view, run, and save command files.
You can execute command files in any of the following ways from Interactive SQL:
You can use the Interactive SQL READ statement to execute command files. For example, the following statement executes the file temp.sql:
You can load a command file into the SQL Statements pane and execute it directly from there.
You load command files into the SQL Statements pane by choosing File » Open. Enter the file name, for example temp.sql, when prompted.
You can run a command file without loading it by choosing File » Run Script.
You can supply a command file as a command line argument for Interactive SQL.
On Windows platforms you can make Interactive SQL the default editor for .sql command files. This lets you double-click the file so that its contents appears in the SQL Statements pane of Interactive SQL.
From Interactive SQL, choose Tools » Options.
In the left pane, click General.
Click Make Interactive SQL The Default Editor For .SQL Files And Plan Files.
For more information about using Interactive SQL with command files, see:
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|