| <?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> |