| <?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-us" xml:lang="en-us"> |
| <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="task"/> |
| <meta name="DC.Title" content="Filtering SQL Results History"/> |
| <meta name="abstract" content="Set filtering options for the SQL Results history to limit the visible results sets."/> |
| <meta name="description" content="Set filtering options for the SQL Results history to limit the visible results sets."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700480170.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700492108.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700493499.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700494983.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700496577.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700497983.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\dmp\en\source\t_filtering_sql_results_history.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="t_581t4r836_761_r4781t7_787t4r2_060606"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:28:19]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700499390"/> |
| <meta name="DC.Language" content="en-US"/> |
| <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">Filtering SQL Results History</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700499390"><a name="asc1229700499390"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1"> Filtering SQL Results History</h1> |
| |
| |
| |
| <div><p>Set filtering options for the SQL Results history to limit |
| the visible results sets. |
| </p> |
| |
| <a name="asc1229700499390__steps_603CFDC1F4B94D45ADE7CBAB2D9E3B27"><!-- --></a><ol id="asc1229700499390__steps_603CFDC1F4B94D45ADE7CBAB2D9E3B27"> |
| <li id="asc1229700499390__step_5C6B0045587844048BF4694003F1C0FF"><a name="asc1229700499390__step_5C6B0045587844048BF4694003F1C0FF"><!-- --></a> |
| <span>In SQL Results view, select |
| <span class="uicontrol">Filters</span> from the view pull-down menu.</span> |
| </li> |
| |
| <li id="asc1229700499390__step_ED97F8977FEB43A99C74EA09384BF019"><a name="asc1229700499390__step_ED97F8977FEB43A99C74EA09384BF019"><!-- --></a> |
| <span>Specify which |
| options to view in the SQL results history.</span> |
| <a name="asc1229700499390__choicetable_E3733E4FE46C4E5B8F65E0F8516F0856"><!-- --></a> |
| <table border="1" frame="hsides" rules="rows" cellpadding="4" cellspacing="0" summary="" class="choicetableborder" id="asc1229700499390__choicetable_E3733E4FE46C4E5B8F65E0F8516F0856"> |
| <thead><tr><th valign="bottom" align="left" id="d11232e54-option">Filtering |
| option</th> |
| <th valign="bottom" align="left" id="d11232e54-desc">Action</th></tr></thead> |
| <tbody> |
| |
| <tr> |
| <td valign="top" headers="d11232e54-option" id="d11232e67"><strong>Connection Profiles |
| </strong></td> |
| |
| <td valign="top" headers="d11232e54-desc d11232e67">Deselect one or more connection profiles to remove the result sets from view. |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td valign="top" headers="d11232e54-option" id="d11232e76"><strong>Limit Visible History To |
| </strong></td> |
| |
| <td valign="top" headers="d11232e54-desc d11232e76">Indicate the maximum number of entries to display in the History pane. |
| The default is 50.</td> |
| |
| </tr> |
| |
| <tr> |
| <td valign="top" headers="d11232e54-option" id="d11232e85"><strong>Display Results of Unresolvable Connection |
| Profiles</strong></td> |
| |
| <td valign="top" headers="d11232e54-desc d11232e85">View results for deleted profiles or profiles with changed |
| names.</td> |
| |
| </tr> |
| |
| <tr> |
| <td valign="top" headers="d11232e54-option" id="d11232e94"><strong>Result Status |
| </strong></td> |
| |
| <td valign="top" headers="d11232e54-desc d11232e94">Select which statuses to view.</td> |
| |
| </tr> |
| |
| </tbody></table> |
| |
| </li> |
| |
| <li id="asc1229700499390__step_53DEA142D5344EDBA63C554DF302F6E0"><a name="asc1229700499390__step_53DEA142D5344EDBA63C554DF302F6E0"><!-- --></a> |
| <span>Click |
| <span class="uicontrol">OK</span>.</span> |
| </li> |
| |
| </ol> |
| |
| </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/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><a href="../../doc/html/asc1229700492108.html" title="You can terminate the execution of a procedural routine object or SQL statement from the SQL Results view. Terminating the execution of an object or SQL statement stops further results from being displayed for the corresponding query.">Terminating Execution in SQL Results View</a></div> |
| <div><a href="../../doc/html/asc1229700493499.html" title="In SQL Results view, you can export a single result set or all execution results.">Exporting SQL Execution Results</a></div> |
| <div><a href="../../doc/html/asc1229700494983.html" title="After you execute SQL queries or run objects, you can save the results to a project from SQL Results view.">Saving Execution Results to a Project</a></div> |
| <div><a href="../../doc/html/asc1229700496577.html" title="Remove query results from the History frame of the SQL Results view.">Removing Results from SQL Results View</a></div> |
| <div><a href="../../doc/html/asc1229700497983.html" title="Save the SQL Results view history to a log file that includes the history summary and the result sets.">Saving SQL Results History</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |