Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » Interactive SQL help » Options window: SQL Anywhere tab or Options window: UltraLite tab


Results tab


Display null values as   Specify how you want nulls to appear in table columns. You can use any string for this value. The default value is (NULL). If this field is blank, null values appear as an empty string. See nulls option [Interactive SQL].

Maximum number of rows to display   Specify the maximum number of rows that can appear in the Results pane. The default is 500. See isql_maximum_displayed_rows option [Interactive SQL].

Truncation length   Specify the number of characters that can appear in each column in the Results pane. If you specify a value of 0, the columns are not truncated. The default is 256. See truncation_length option [Interactive SQL].


Scrollable table   Select this option to display the result set in a scrollable table. You can edit the result set in this format. This is the default.

The following options are enabled when you select Scrollable table.

  • Automatically refetch results   Select this option if you want Interactive SQL to automatically regenerate the result set after you execute an INSERT, UPDATE, or DELETE statement. This is on by default.

    See auto_refetch option [Interactive SQL].

  • Show row number   Select this option if you want row numbers to appear beside your result set in the Results pane. This is the default.

  • Disable editing   Select this option to make result sets read only. This option applies to result sets of queries that you execute after selecting this option.

  • Automatically release database locks   Select this option to have Interactive SQL attempt to release the locks it creates during your transaction.

    When this option is selected, after you execute a statement that returns a result set, Interactive SQL checks if your connection has any uncommitted changes in the database. If none exist, then Interactive SQL releases your schema locks; otherwise, Interactive SQL does not release your schema locks. That is, Interactive SQL does not release your schema locks if you have any uncommitted changes to the database.

  • Font   Select one of the following options to specify the font that is used for table data in the Interactive SQL Results pane:

    • System font   Select this option to use the computer's normal text font. This is the default.

    • Editor font   Select this option to use the same font as the SQL Statements pane.

    • Custom font   Select this option to specify an arbitrary font, font style, and point size you want to use. Click Browse to select the settings in the Font window.

Text   Select this option to display the result set as text using a monospaced font. The result set is not editable in this format.

Results Processing

The following options let you specify which result set(s) are displayed when statements are run.

Show results from the last statement   Prints the result set from the last statement. This is the default.

Show results from each statement   Prints the result set for each statement.

Show only the first result set   Prints the first result set returned. This is the default.

Show all result sets   Prints all result sets. Select this option if you want Interactive SQL to display multiple result sets in the Results pane when you execute a procedure that returns multiple SELECT statements. When running in windowed mode, each result set appears on a separate tab in the Results pane. The setting of this option also applies when running Interactive SQL as a command line program. By default, Interactive SQL does not display multiple result sets.


Interactive SQL can run out of memory when displaying large result sets. This problem may occur if you do any of the following:

  • set the Maximum Number of Rows to Display option to All Rows

  • select Show Results From Each Statement

  • select Show All Result Sets

If Interactive SQL runs out of memory, it reports the problem but does not display the result set.