Results (ISQL) Options

Go Up to Configuring Feature Options

The Options Editor’s Results tab lets you specify operational and appearance details for the SQL Editor.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.

Note: For information on using the SQL Editor, see Coding Environments/Editors.

The table below describes the options and functionality on the Results tab:

Interface Element	Options and descriptions
Results Option pane	Result Window	Single Window - Displays all results in one tabbed result window. Multiple result sets together in the window. Single Window and Multiple Windows options are mutually exclusive. Multiple Windows - Displays multiple result sets one result set per window. Attached to Editor - Sets results as tabbed windows attached to the ISQL window. Used in conjunction with Single Window option or Multiple Window option. Attached and Unattached options are mutually exclusive. Unattached - Sets results appear separate from the ISQL Window. Used in conjunction with Single Window option or Multiple Windows option. Reuse Window - Sets new result sets to overwrite any current result sets in an open Result Window. Only valid for Single and Attached to Editor combination.
	Results File	Mail File Type - Selects the file type to use when sending result sets via a MAPI-compliant mail package. Valid formats include the proprietary Results type, Tab delimited, Comma separated, and HTML. Schedule File Type - Selects the schedule file type. Valid formats include Tab delimited, Comma separated, and HTML. Include column titles when saving - Includes column titles when saving a result set. If this option is turned off, result sets are not saved.
	Result Set Options	Default Rowcount - Lets you limit the number of rows returned to the result window of the ISQL window (default 0). Sybase ASE and SQL Server: Text Size (bytes) - Lets you specify the text size (default 8192). Oracle:LONG Size (bytes) - Lets you specify the LONG size (default 8192). LOB Preview: Text Size (bytes) - Specifies the length of the preview of LOB column data (default 4096).
	Sort Type	Lets you select a result sorting: Alphameric or Lexicographic.
Format pane	Column Formatting	Auto Format (Best Fit) - Sets column widths automatically to accommodate the longest piece of data in a column. Large queries depend on the longest row formatting, so activating this option can affect performance. Use pre-defined column - Lets you select column type and character length
	Enable Date/Time Format	Lets you select the date/time format.
	Format	Standard Grid - Displays all result sets in a standard grid format. Result sets are displayed in grid format in SQL Editors that are opened after you have selected this option. This has no effect on ISQL Editors that are already open. HTML - Displays all result sets as HTML tables. Result sets are displaedin HTML format in ISQL Editors that are opened after you have selected this option. This has no effect on SQL Editors that are already open. ASCII Text - Displays all result sets as ASCII Text. Result sets are displayed in ASCII Text format in ISQL Editors that are opened after you have selected this option. There is no effect on SQL Editors that are already open. Grid Font and Printer Font buttons - Open a Font dialog, letting you select the font, style, and size for the result sets grid or printed result sets. Enable Locale - If selected, numbers are formatted (thousands separator, decimal separator) as locale-specific strings. If unselected, numbers are formatted according to the C locale.