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.
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|