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.
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.
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
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |