blob: d17d82e529ba5dc220bf5d0e6c6c7145c3be5837 [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-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>