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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » Interactive SQL Help » Introduction to Interactive SQL dialogs

Options dialog: General tab Next Page

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.

See nulls option [Interactive SQL].

Maximum number of rows to display    Specify the maximum number of rows that 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 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.

See truncation_length option [Interactive SQL].

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. When running in windowed mode, each result set appears on a separate tab in the Results pane. The setting of this option also applies to Interactive SQL when running in command prompt mode. By default, Interactive SQL does not display multiple 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.

See auto_refetch option [Interactive SQL].

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

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

See also