You can execute multiple SQL statements from Interactive SQL as long as each statement ends with a command delimiter. The command delimiter is set with the command_delimiter option, and is a semicolon (;) by default. An alternative to using the semicolon is to enter the separator go on a line by itself, at the beginning of the line. See command_delimiter option [Interactive SQL].
By default, Interactive SQL shows the first result set of the most-recently executed statement.
From Tools, choose Options, choose one of the following:
SQL Anywhere » Results.
UltraLite » Results.
Choose Show All Result Sets.
Choose Show results from each statement.
Click OK
You can press F9 to execute only the selected text in the SQL Statements pane.
You can press Shift+F9 to execute only the selected statement in the SQL Statements pane and select the next statement for execution.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |