Setting SQL Results View Preferences

Specify the behavior of the SQL Results view.

Note

Setting limits on data retrieved or displayed is recommended for testing queries on very large or wide tables.

  1. Select Window|Preferences from the main menu bar.

    The Preferences dialog box appears.

  2. In the left pane, expand Sybase, Inc, then expand Database Development and select SQL Results View.

  3. Select options for SQL Results view:

    SQL Results View preferences

    FieldExplanation
    Display Window Select a window display style:

    • Single tab—Display execution results in a single tab, with status details at the end. For a single statement with multiple results, display result sets one after another in the same tab. Enables Save All Results. Disables Save Result. To save a single result in single tab grid mode, right-click on the result set and choose Save Single Result.

    • Multiple tabs—Display execution status and each result for the current statement in a separate window. Enables Save Result and Save All Results.

    Display ModeSelect a results display mode:

    • Text mode: like isql output when in single tab mode

    • Grid mode: like Interactive SQL window

    Show column headingsSelect to show column headings in the results view:

    Always enabled for grid mode.

    Default for Text mode.

    Show row numberSelect to show row numbers in results view:

    • Always enabled for text mode

    • Default for grid mode

    Show row count message

    Select to show number of rows affected.

    • Always enabled for text mode

    • Default for grid mode

    In text mode, row count appears at the end of the results. In grid mode, row count appears in the Status window.

    Maximum rows to retrieve:Enter number of rows to retrieve. Default is 0 (retrieves all rows).

    Set a maximum to improve performance when testing queries, and to avoid running out of memory when retrieving data from very large tables, for example, a hundred million rows.

    Maximum display row count: Enter number of rows to display in the results view.

    To see all results, set Maximum rows to retrieve to 0, and then save to a file.

    Text image size:

    Enter maximum width of data to retrieve, for Adaptive Server Enterprise only. Default is 32767 bytes.

    Select to improve performance and to avoid running out of memory when retrieving very wide data. Datatypes long binary, long varchar, and types based on them including text, image, xml, can be 50MB or more.

    Display null value as:Enter characters to display when the value is NULL. Default is NULL.

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com