blob: 5f826e6f5d44a3ab33bd74707c58402e8c8090c3 [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="Saving Execution Results to a Project"/>
<meta name="abstract" content="After you execute SQL queries or run objects, you can save the results to a project from SQL Results view."/>
<meta name="description" content="After you execute SQL queries or run objects, you can save the results to a project from SQL Results view."/>
<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/asc1229700496577.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700497983.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700499390.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_saving_execution_results.xml"/>
<meta name="DitaCms:MapImporter:OriginalObjectId" content="t_719836_414c8t843_r4781t7_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:14]"/>
<meta name="DC.Format" content="XHTML"/>
<meta name="DC.Identifier" content="asc1229700494983"/>
<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">Saving Execution Results to a Project</title>
<meta name="provider" content="Sybase, Inc."/></head>
<body id="asc1229700494983"><a name="asc1229700494983"><!-- --></a>
<br/>
<h1 class="topictitle1"> Saving Execution Results to a Project</h1>
<div><p>After you execute SQL queries or run objects, you can save the results to a project from SQL Results view.
</p>
<div class="p" id="asc1229700494983__prereq_6CA0D27C5421445D873E413A659A2107"><a name="asc1229700494983__prereq_6CA0D27C5421445D873E413A659A2107"><!-- --></a><strong class="prereq-title">Prerequisites </strong>
<p>Open SQL Results view.</p>
</div>
<a name="asc1229700494983__steps_81B8A37226004BBB9B37CD29036C0884"><!-- --></a><ol id="asc1229700494983__steps_81B8A37226004BBB9B37CD29036C0884">
<li class="stepexpand" id="asc1229700494983__step_B7029A9F3EDF47B6A9993923ED73747C"><a name="asc1229700494983__step_B7029A9F3EDF47B6A9993923ED73747C"><!-- --></a>
<span>If in Single Tab mode, switch to Text (multitab) mode.</span>
</li>
<li class="stepexpand" id="asc1229700494983__step_6B3E67808D8A45D8A93A519C0827BA95"><a name="asc1229700494983__step_6B3E67808D8A45D8A93A519C0827BA95"><!-- --></a>
<span>Save a single result or all results.</span>
<a name="asc1229700494983__choicetable_05AFCD85931640BD99D36C432234E104"><!-- --></a>
<table border="1" frame="hsides" rules="rows" cellpadding="4" cellspacing="0" summary="" class="choicetableborder" id="asc1229700494983__choicetable_05AFCD85931640BD99D36C432234E104">
<thead><tr><th valign="bottom" align="left" id="d10857e57-option">To save</th>
<th valign="bottom" align="left" id="d10857e57-desc">Do this</th></tr></thead>
<tbody>
<tr>
<td valign="top" headers="d10857e57-option" id="d10857e70"><strong>A single result</strong></td>
<td valign="top" headers="d10857e57-desc d10857e70">In the
<span class="uicontrol">Result</span> tab, , right-click and select
<span class="menucascade">
<span class="uicontrol">Save</span>
&gt; <span class="uicontrol">Current Result</span>
</span>.</td>
</tr>
<tr>
<td valign="top" headers="d10857e57-option" id="d10857e91"><strong>All results</strong></td>
<td valign="top" headers="d10857e57-desc d10857e91">In the
<span class="uicontrol">Result</span> tab, right-click and select
<span class="menucascade">
<span class="uicontrol">Save</span>
&gt; <span class="uicontrol">All Results</span>
</span>.</td>
</tr>
</tbody></table>
</li>
<li class="stepexpand" id="asc1229700494983__step_50FBC92361464222A017C60D6354F42E"><a name="asc1229700494983__step_50FBC92361464222A017C60D6354F42E"><!-- --></a>
<span>Select the project folder in which to save the result set.</span>
</li>
<li class="stepexpand" id="asc1229700494983__step_7206378446FC49F2BBC1BAEB96542BDE"><a name="asc1229700494983__step_7206378446FC49F2BBC1BAEB96542BDE"><!-- --></a>
<span>Enter the
<span class="uicontrol">File Name</span>.
</span>
</li>
<li class="stepexpand" id="asc1229700494983__step_5C584689D0A447858C59267B36F576C8"><a name="asc1229700494983__step_5C584689D0A447858C59267B36F576C8"><!-- --></a>
<span>Select the
<span class="uicontrol">File Type</span>.
</span>
</li>
<li class="stepexpand" id="asc1229700494983__step_589311FB522F47CC9DD6545F12D91FBE"><a name="asc1229700494983__step_589311FB522F47CC9DD6545F12D91FBE"><!-- --></a>
<span>Specify the <span class="uicontrol">Export Options</span>.</span>
</li>
<li class="stepexpand" id="asc1229700494983__step_CD4C66249CA243DE9B5901D2623DD839"><a name="asc1229700494983__step_CD4C66249CA243DE9B5901D2623DD839"><!-- --></a>
<span>Click
<span class="uicontrol">OK</span>.</span>
<p>The result set opens in the editor or external tool for the
format you chose.
</p>
</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/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><a href="../../doc/html/asc1229700499390.html" title="Set filtering options for the SQL Results history to limit the visible results sets.">Filtering SQL Results History</a></div>
</div>
</div>
<div/>
</body>
</html>