SQL Anywhere Studio Help
  Interactive SQL Help
    Options dialog

Options dialog: Results tab

The Results tab of the Options dialog in Interactive SQL has the following components:

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

  For more information, see NULLS option [ISQL].

• Maximum number of rows to display    Specify the maximum number of rows that appear in the Results pane. The default is 500.

• Truncation length    Specify the number of characters that are displayed in each column in the Results pane. If you enter a value of 0, the columns are not truncated. The default is 256.

  For more information, see TRUNCATION_LENGTH option [ISQL].

• Show multiple 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. Each result set appears on a separate tab in the Results pane. By default, Interactive SQL does not display multiple result sets.

  If you use the jConnect driver and select the Show Multiple Result Sets option, Interactive SQL must wait until the entire result set is retrieved before any rows appear in the Results pane. This can result in slower processing of large result sets.

• Show row number    

  Select this option if you want row numbers to appear beside your results in the Results pane. This option is on by default.

• 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. By default, Interactive SQL refetches result sets.

  For more information, see AUTO_REFETCH option [ISQL].

• When running in console mode, which result sets do you want to see?    The following options let you specify which result set(s) are printed when a .SQL file is run. This option has no effect when running in windowed mode and is set on a per-machine basis. This option is set only for the current Interactive SQL unless you click the Make Permanent button.

  • The last one    Prints the result set from the last statement in the file.

  • All of them    Prints result sets for each statement in the file that returns a result set.

  • None    Does not print any result sets.

    For more information, see ISQL_PRINT_RESULT_SET option [ISQL].

See also 

SET OPTION statement [Interactive SQL]