| <?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="task"/> |
| <meta name="DC.Title" content="Viewing SQL Results"/> |
| <meta name="abstract" content="Use the SQL Results view to see the results of an executed SQL query or routine procedural object."/> |
| <meta name="description" content="Use the SQL Results view to see the results of an executed SQL query or routine procedural object."/> |
| <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/asc1229700466482.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700461576.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700463513.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700467920.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700470998.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700478717.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/asc1229700499390.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700490436.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700490436.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700412058.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.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\workspace\dmp\en\source\t_Viewing_SQL_Results.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="task_B1A2B482D2FB4349A89626B561EA12A1"/> |
| <meta name="status" content="Authoring:work"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:user" content="updates for 2.1.2"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700480170"/> |
| <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">Viewing SQL Results</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700480170"><a name="asc1229700480170"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Viewing SQL Results</h1> |
| |
| |
| |
| |
| <div><p>Use the SQL Results view to see the results of an executed SQL |
| query or |
| <span>routine |
| </span> |
| <span>procedural |
| </span>object. |
| </p> |
| |
| <a name="asc1229700480170__steps_B0C04B889390451296533EA5A6478941"><!-- --></a><ol id="asc1229700480170__steps_B0C04B889390451296533EA5A6478941"> |
| <li class="stepexpand" id="asc1229700480170__step_FD6CF4A4B23646258CCA278B130AF7CE"><a name="asc1229700480170__step_FD6CF4A4B23646258CCA278B130AF7CE"><!-- --></a> |
| |
| <span>Execute your SQL |
| query, code to create a database object, or |
| a <span>routine |
| </span> |
| <span>procedural |
| </span>object.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700480170__step_8018AD3981B94E01BB9095E44D6182F8"><a name="asc1229700480170__step_8018AD3981B94E01BB9095E44D6182F8"><!-- --></a> |
| <span>Examine the |
| execution results in SQL Results view.</span> |
| |
| <br/><ul> |
| <li>View the status of the query or object, the text |
| of the query, the date and time, and error or informational messages. |
| </li> |
| |
| <li>Search result sets using standard Eclipse Find/Replace functionality.</li> |
| |
| <li>Save a group (SQL statement, its children statements, and all their execution results) to a log file.</li> |
| |
| <li>Display or save all SQL results in a file similar to iSQL command output.</li> |
| |
| </ul> |
| |
| <p/> |
| |
| |
| |
| <div class="note" id="asc1229700480170__note_BB588989F7C24A2A86B42B12D473DABD"><a name="asc1229700480170__note_BB588989F7C24A2A86B42B12D473DABD"><!-- --></a><span class="notetitle">Note:</span> The maximum number of result tabs that display is determined via the SQL Results view preference page. Any result sets that exceed the maximum number do not display. To view more result tabs, increase the limit. To view all results, export all results to a file and view the results in an external editor.</div> |
| |
| |
| </li> |
| |
| </ol> |
| |
| </div> |
| |
| <div><div class="relconcepts"><strong>Related concepts</strong><br/> |
| <div><a href="../../doc/html/asc1229700478717.html" title="Procedural Routine objects are the building blocks of a database application. Database Development builds the skeleton for procedural routine objects and provides tools to populate the body of the object with the appropriate SQL.">Procedural Routine Objects</a></div> |
| <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/asc1229700466482.html" title="You can execute a SQL file from the SQL File Editor or from WorkSpace Navigator.">Executing a SQL File</a></div> |
| <div><a href="../../doc/html/asc1229700461576.html" title="Execute a SQL statement from an editor.">Executing a SQL Statement</a></div> |
| <div><a href="../../doc/html/asc1229700463513.html" title="Use the Eclipse launch configuration mechanism to run an ad hoc SQL query.">Running an Ad Hoc SQL Statement</a></div> |
| <div><a href="../../doc/html/asc1229700467920.html" title="Run a routine object to obtain SQL results from the database.">Running a Routine Object</a></div> |
| <div><a href="../../doc/html/asc1229700470998.html" title="Use the launch configuration feature to run user-defined functions, events, stored procedures, triggers, and ad hoc queries. Creating your own launch configurations is optional, but it can help you perform more consistent, robust, and efficient iterative testing of routine procedural objects.">Creating a Launch Configuration for Routine Procedural Objects</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><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 class="relref"><strong>Related reference</strong><br/> |
| <div><a href="../../doc/html/asc1229700412058.html" title="The SQL Results view preferences determine the behavior of the SQL Results view.">SQL Results View Options 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> |
