You can execute multiple SQL statements from Interactive SQL as long as each statement ends with a command delimiter.
There are no prerequisites for this task.
Context and remarks
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.
In Interactive SQL, type your queries in the SQL Statements pane.
Choose one of the following options to execute the SQL statements:
|Execute all SQL statements||
Press F5, or click SQL » Execute to execute all statements.
|Execute selected SQL statements||
Select the statements, then press F9, or click SQL » Execute Selection to execute the selected statements.
|Execute SQL statements one at a time||
Place your cursor in the statement that you want to execute, then press Shift+F9, or click SQL » Single Step to execute the statement.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|