Executing multiple SQL statements

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

Results processing

By default, Interactive SQL shows the first result set of the most-recently executed statement.

To see all the result sets
  1. From Tools, choose Options, choose one of the following:

    • SQL Anywhere » Results.

    • UltraLite » Results.

  2. Choose Show All Result Sets.

  3. Choose Show results from each statement.

  4. Click OK

Tip

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.

See also