| <?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="Exporting SQL Execution Results"/> |
| <meta name="abstract" content="In SQL Results view, you can export a single result set or all execution results."/> |
| <meta name="description" content="In SQL Results view, you can export a single result set or all execution results."/> |
| <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/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/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_exporting_sql_execution_results.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="t_4154rt836_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:13]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700493499"/> |
| <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">Exporting SQL Execution Results</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700493499"><a name="asc1229700493499"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1"> Exporting SQL Execution Results</h1> |
| |
| |
| |
| <div><p>In SQL Results view, you can export a single result set or all execution results.</p> |
| |
| <div class="p" id="asc1229700493499__prereq_6CA0D27C5421445D873E413A659A2107"><a name="asc1229700493499__prereq_6CA0D27C5421445D873E413A659A2107"><!-- --></a><strong class="prereq-title">Prerequisites </strong> |
| <p>Open SQL Results view.</p> |
| |
| </div> |
| |
| <div class="section" id="asc1229700493499__context_92E05986BA5A4F7A974D08424EE7337E"><a name="asc1229700493499__context_92E05986BA5A4F7A974D08424EE7337E"><!-- --></a> |
| <p>Exporting saves the result set to a file outside of the workspace project for use with other applications.</p> |
| |
| </div> |
| |
| <a name="asc1229700493499__steps_6EC1894509E7415287B410344B6207A1"><!-- --></a><ol id="asc1229700493499__steps_6EC1894509E7415287B410344B6207A1"> |
| <li class="stepexpand" id="asc1229700493499__step_B7029A9F3EDF47B6A9993923ED73747C"><a name="asc1229700493499__step_B7029A9F3EDF47B6A9993923ED73747C"><!-- --></a> |
| <span>If in Single Tab mode, switch to Text (multitab) mode.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700493499__step_6B3E67808D8A45D8A93A519C0827BA95"><a name="asc1229700493499__step_6B3E67808D8A45D8A93A519C0827BA95"><!-- --></a> |
| <span>Export a single result or all results.</span> |
| <a name="asc1229700493499__choicetable_05AFCD85931640BD99D36C432234E104"><!-- --></a> |
| <table border="1" frame="hsides" rules="rows" cellpadding="4" cellspacing="0" summary="" class="choicetableborder" id="asc1229700493499__choicetable_05AFCD85931640BD99D36C432234E104"> |
| <thead><tr><th valign="bottom" align="left" id="d10654e63-option">To export</th> |
| <th valign="bottom" align="left" id="d10654e63-desc">Do this</th></tr></thead> |
| <tbody> |
| |
| <tr> |
| <td valign="top" headers="d10654e63-option" id="d10654e76"><strong>A single result</strong></td> |
| |
| <td valign="top" headers="d10654e63-desc d10654e76">In the |
| <span class="uicontrol">Result</span> tab, , right-click and select |
| <span class="menucascade"> |
| <span class="uicontrol">Export</span> |
| > <span class="uicontrol">Current Result</span> |
| </span>.</td> |
| |
| </tr> |
| |
| <tr> |
| <td valign="top" headers="d10654e63-option" id="d10654e97"><strong>All results</strong></td> |
| |
| <td valign="top" headers="d10654e63-desc d10654e97">In the |
| <span class="uicontrol">Result</span> tab, right-click and select |
| <span class="menucascade"> |
| <span class="uicontrol">Export</span> |
| > <span class="uicontrol">All Results</span> |
| </span>.</td> |
| |
| </tr> |
| |
| </tbody></table> |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700493499__step_BB5DACF9972D45DFBAE9F8E92CF3ED04"><a name="asc1229700493499__step_BB5DACF9972D45DFBAE9F8E92CF3ED04"><!-- --></a> |
| <span>Enter a <span class="uicontrol">File Name</span>, or click <span class="uicontrol">Browse</span> to find an existing file or save the results to a specific location and file name.</span> |
| |
| |
| <p>If you do not specify a file location, the file is saved to the <span class="filepath"> |
| <var class="varname"><installation></var>\Eclipse</span> |
| <span class="filepath"> |
| <var class="varname"><installation></var>\eclipse</span> directory.</p> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700493499__step_320E9A5BC07C4CC4BB9410438528C0D8"><a name="asc1229700493499__step_320E9A5BC07C4CC4BB9410438528C0D8"><!-- --></a> |
| <span>Select a file |
| <span class="uicontrol">Format</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700493499__step_63EF4E737C6D4FEA84A229BB080C6BE3"><a name="asc1229700493499__step_63EF4E737C6D4FEA84A229BB080C6BE3"><!-- --></a> |
| <span>Select the <span class="uicontrol">Export Options</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700493499__step_36462E7C015C40108DC9BB32A0BE3653"><a name="asc1229700493499__step_36462E7C015C40108DC9BB32A0BE3653"><!-- --></a> |
| <span>Click<span class="uicontrol"> Finish</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/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><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> |
