blob: d936b3964bf016178b63d8f3ad96edf1a280ebf6 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="copyright" content="(C) Copyright 2005"/>
<meta name="DC.rights.owner" content="(C) Copyright 2005"/>
<meta name="DC.Type" content="reference"/>
<meta name="DC.Title" content="SQL Results View Options Preferences"/>
<meta name="abstract" content="The SQL Results view preferences determine the behavior of the SQL Results view."/>
<meta name="description" content="The SQL Results view preferences determine the behavior of the SQL Results view."/>
<meta name="DC.subject" content="sybase_workspace, database_development, dtp"/>
<meta name="keywords" content="sybase_workspace, database_development, dtp"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700399339.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700400855.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700404058.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700410527.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700397808.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700413480.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700414871.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700416261.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700480170.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700490436.html"/>
<meta name="DC.Creator" content="ekapner"/>
<meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\workspace\ws\en\source\r_sql_results_view_preferences.xml"/>
<meta name="DitaCms:MapImporter:OriginalObjectId" content="reference_144E5FF9F3DE45199DA2D606A2A78E76"/>
<meta name="status" content="Authoring:initial"/>
<meta name="source" content="Map Importer"/>
<meta name="comment:system" content="Imported topic [2008/12/19 08:26:51]"/>
<meta name="DC.Format" content="XHTML"/>
<meta name="DC.Identifier" content="asc1229700412058"/>
<meta name="DC.Language" content="en"/>
<link rel="stylesheet" type="text/css" href="../../styles/commonltr.css"/>
<link rel="stylesheet" type="text/css" href="../../styles/doc.css"/>
<title xmlns:xs="http://www.w3.org/2001/XMLSchema">SQL Results View Options Preferences</title>
<meta name="provider" content="Sybase, Inc."/></head>
<body id="asc1229700412058"><a name="asc1229700412058"><!-- --></a>
<br/>
<h1 class="topictitle1">SQL Results View Options Preferences</h1>
<div><p>The SQL Results view preferences determine the behavior of the SQL
Results view.</p>
<div class="tablenoborder"><a name="asc1229700412058__table_C819C45562254203860AC97C45CAA30C"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700412058__table_C819C45562254203860AC97C45CAA30C" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 1. SQL Results view options</span></caption>
<thead align="left">
<tr>
<th class="cellrowborder" valign="top" width="28.328611898016998%" id="d2208e59">Field
</th>
<th class="cellrowborder" valign="top" width="71.671388101983%" id="d2208e62">Explanation
</th>
</tr>
</thead>
<tbody>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Display Window
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Select a window display style:
<br/><a name="asc1229700412058__ul_D0490724C2134522B741A40799A605A5"><!-- --></a><ul id="asc1229700412058__ul_D0490724C2134522B741A40799A605A5">
<li id="asc1229700412058__li_7FFCA49B1D254BDE82B96DCEC5A30899"><a name="asc1229700412058__li_7FFCA49B1D254BDE82B96DCEC5A30899"><!-- --></a>
<span class="uicontrol">
Single Window</span> — display execution results in a single window, with
status details at the end. For a single statement with multiple results,
display result sets one after another in the same window. </li>
<li id="asc1229700412058__li_067D874ECB6948519F446D3E62CCC25E"><a name="asc1229700412058__li_067D874ECB6948519F446D3E62CCC25E"><!-- --></a>
<span class="uicontrol">Multiple Windows</span> — display execution
status and each result for the current statement in a separate window. </li>
</ul>
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Display Mode
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Select a results display mode:
<br/><a name="asc1229700412058__ul_C7714CB6F3B644C7B90459DDBEE08248"><!-- --></a><ul id="asc1229700412058__ul_C7714CB6F3B644C7B90459DDBEE08248">
<li id="asc1229700412058__li_3D91E2D51B444C99849119216F5682E9"><a name="asc1229700412058__li_3D91E2D51B444C99849119216F5682E9"><!-- --></a>
<span class="uicontrol">Text Mode</span> — similar to iSQL output when in
single-tab mode.
</li>
<li id="asc1229700412058__li_8B1BE832F96144F988868EBD1C4CCD7F"><a name="asc1229700412058__li_8B1BE832F96144F988868EBD1C4CCD7F"><!-- --></a>
<span class="uicontrol">Grid Mode</span> — similar to the Interactive SQL
window.
</li>
</ul>
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Show Column Headings
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Show column headings in the results view.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Show Row Number
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Show row numbers in results view. <div class="p">
<br/><a name="asc1229700412058__ul_2DFB85D53A2F400DAB74B3845625A73A"><!-- --></a><ul id="asc1229700412058__ul_2DFB85D53A2F400DAB74B3845625A73A">
<li id="asc1229700412058__li_8B46B6B9A5E94640A5223F445C7AB999"><a name="asc1229700412058__li_8B46B6B9A5E94640A5223F445C7AB999"><!-- --></a>In text mode, this property
is always enabled.</li>
<li id="asc1229700412058__li_B2F3E5FB374948758681F9954FBD6ADE"><a name="asc1229700412058__li_B2F3E5FB374948758681F9954FBD6ADE"><!-- --></a>In grid mode, this property is selected by default.</li>
</ul>
</div>
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Show Row Count Message
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Show number of rows affected. <div class="p">
<br/><a name="asc1229700412058__ul_D048AD4089E9402CACAAC10560646F28"><!-- --></a><ul id="asc1229700412058__ul_D048AD4089E9402CACAAC10560646F28">
<li id="asc1229700412058__li_D2D93B11FEB345CCB9CA716F0F779BC4"><a name="asc1229700412058__li_D2D93B11FEB345CCB9CA716F0F779BC4"><!-- --></a>In text mode, this property is
always enabled. Row count appears at the end of the results.
</li>
<li id="asc1229700412058__li_284F6BBF0C544856A51B268AB5D30D84"><a name="asc1229700412058__li_284F6BBF0C544856A51B268AB5D30D84"><!-- --></a>In grid mode, this property is selected by default. Row count appears in the Status window.
</li>
</ul>
</div>
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Max Row Count
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Enter the number of rows to retrieve from the result set. The default is 0
(retrieve all rows).
<p>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, tables with a hundred million rows.
</p>
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Max Display Row Count
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Enter number of rows to display in the results view.
<p>To see all results, set
<span class="uicontrol">Maximum Rows to Retrieve</span> to 0, and
then save to a file.
</p>
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Display Null Value As
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Enter characters to display when the value is NULL.
Default is NULL.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Split All Messages Into Multiple Message Tabs
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">Split messages among more than one
tab.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Limit Tabs Number to
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">If you selected
<span class="uicontrol">Multiple Windows</span> for the
<span class="uicontrol">Display Window</span> preference, enter a
maximum number of tabs.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="28.328611898016998%" headers="d2208e59 ">Limit Visible Tables Number to
</td>
<td class="cellrowborder" valign="top" width="71.671388101983%" headers="d2208e62 ">If you selected
<span class="uicontrol">Single Window</span> for the
<span class="uicontrol">Display Window</span> preference, enter a
maximum number of visible tables.
</td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><a name="asc1229700412058__table_8A464760A6EF4E2CA2E78BB7F71A408B"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700412058__table_8A464760A6EF4E2CA2E78BB7F71A408B" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 2. SQL Results view options: Sybase_ASE</span></caption>
<thead align="left">
<tr>
<th class="cellrowborder" valign="top" id="d2208e262">Field
</th>
<th class="cellrowborder" valign="top" id="d2208e265">Explanation
</th>
</tr>
</thead>
<tbody>
<tr>
<td class="cellrowborder" valign="top" headers="d2208e262 "> Text Image Size
</td>
<td class="cellrowborder" valign="top" headers="d2208e265 "> Specify the maximum size in bytes of text, unitext, or image data returned.
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div><div class="relconcepts"><strong>Related concepts</strong><br/>
<div><a href="../../doc/html/asc1229700490436.html" title="SQL Results view displays the results of executing SQL statements, running procedural routine objects, and creating database objects.">SQL Results View</a></div>
</div>
<div class="reltasks"><strong>Related tasks</strong><br/>
<div><a href="../../doc/html/asc1229700397808.html" title="Set SQL Development preferences for label decorations, execution plans, SQL Editor, SQL Query Builder, and SQL Results view.">Setting SQL Development Preferences</a></div>
<div><a href="../../doc/html/asc1229700480170.html" title="Use the SQL Results view to see the results of an executed SQL query or routine procedural object.">Viewing SQL Results</a></div>
</div>
<div class="relref"><strong>Related reference</strong><br/>
<div><a href="../../doc/html/asc1229700399339.html" title="Set execution plan view options to specify defaults for viewing query plans.">Execution Plan View Options Preferences</a></div>
<div><a href="../../doc/html/asc1229700400855.html" title="The general user preferences concern executing and debugging procedural objects.">Database Development General Preferences</a></div>
<div><a href="../../doc/html/asc1229700404058.html" title="SQL Editor preferences define the behavior of the SQL File Editor.">SQL Editor Preferences</a></div>
<div><a href="../../doc/html/asc1229700410527.html" title="Indicate the SQL Query Builder preferences.">SQL Query Builder Preferences</a></div>
<div><a href="../../doc/html/asc1229700413480.html" title="Set export format options for the XML format, column delimiters, and encoding.">Export Format Options Preferences</a></div>
<div><a href="../../doc/html/asc1229700414871.html" title="Set history option preferences for the display of history in the SQL Results view.">History Options Preferences</a></div>
<div><a href="../../doc/html/asc1229700416261.html" title="Select the viewer to display SQL results.">Result Set Viewer Preferences</a></div>
</div>
</div>
<div/>
</body>
</html>