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.
To see all the result sets
From Tools, choose Options, choose one of the following:
Choose Show All Result Sets.
Choose Show results from each statement.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|