The Results dialog box has multiple components that let you configure how your results from Interactive SQL appear.
The components are:
Display null values – lets you specify how you want nulls to appear in the table columns when you browse data. The default setting is (NULL).
Maximum number of rows to display – limits the number of rows that appear. The default setting is 500.
Truncation length – limits the number of characters that appear in each column in the Results pane in Interactive SQL. The default setting is 30.
Show multiple result sets – enables or disables the display of multiple result sets. For example, you can use this feature when you create a procedure containing multiple select statements. If this option is enabled, you can see each result set on a separate tab in the Results pane when you call the procedure.
If you are using the jConnect driver, choosing to display multiple result sets requires Interactive SQL to wait for an entire result set to be retrieved before any rows appear. This may result in longer waits for large result sets. This option is off by default.
Show row number – check if you want the row numbers displayed in the result set.
Automatically refetch result – enables or disables the ability of Interactive SQL to automatically regenerate the most recent result set after you execute an insert, update, or delete statement. For example, if you are updating a table with the Results tab in the Results pane displaying the rows about to be affected, this option causes Interactive SQL to automatically refresh the Results tab to reflect the executed changes. This option is on by default.
Console Mode – select how you want the result sets displayed in the console; only the last result sets, all result sets, or no result sets.
Font – select which font you want to use for the result set.
