| <?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="Running an Ad Hoc SQL Statement"/> |
| <meta name="abstract" content="Use the Eclipse launch configuration mechanism to run an ad hoc SQL query."/> |
| <meta name="description" content="Use the Eclipse launch configuration mechanism to run an ad hoc SQL query."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="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/asc1229700480170.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_Running_an_Ad_Hoc_SQL_Statement.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="task_B301B966B571469CB5DC9187AA6A0809"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:27:43]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700463513"/> |
| <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">Running an Ad Hoc SQL Statement</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700463513"><a name="asc1229700463513"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Running an Ad Hoc SQL Statement</h1> |
| |
| |
| |
| <div><p>Use the Eclipse launch configuration mechanism to run an ad hoc |
| SQL query. |
| </p> |
| |
| <div class="p" id="asc1229700463513__prereq_9AFE35B9ACB04526812D9ABF26F83A8A"><a name="asc1229700463513__prereq_9AFE35B9ACB04526812D9ABF26F83A8A"><!-- --></a><strong class="prereq-title">Prerequisites </strong> |
| <p>Make sure that the database server is |
| running. Establish a connection to the database through a connection profile. |
| </p> |
| |
| </div> |
| |
| <a name="asc1229700463513__steps_CF96679B9E8C465F8131CE661FD18C6C"><!-- --></a><ol id="asc1229700463513__steps_CF96679B9E8C465F8131CE661FD18C6C"> |
| <li id="asc1229700463513__step_80BB62B48004450CB022122C3D4688E8"><a name="asc1229700463513__step_80BB62B48004450CB022122C3D4688E8"><!-- --></a> |
| <span>Select |
| <span class="menucascade"> |
| <span class="uicontrol">Run</span> |
| > <span class="uicontrol">Open Run Dialog</span> |
| </span> |
| <span class="menucascade"> |
| <span class="uicontrol">Run</span> |
| > <span class="uicontrol">Run Configurations</span> |
| </span>.</span> |
| </li> |
| |
| <li id="asc1229700463513__step_524B22B1EFA14E318F1F2391C1ED6D43"><a name="asc1229700463513__step_524B22B1EFA14E318F1F2391C1ED6D43"><!-- --></a> |
| <span>In the |
| <span class="uicontrol">Main</span> tab, click <span class="uicontrol">Adhoc SQL</span>.</span> |
| </li> |
| |
| <li id="asc1229700463513__step_648F08CE939A4B29B7A9178B60FEC372"><a name="asc1229700463513__step_648F08CE939A4B29B7A9178B60FEC372"><!-- --></a> |
| <span>Select the |
| connection <span class="uicontrol">Profile</span> and <span class="uicontrol">Database</span>.</span> |
| </li> |
| |
| <li id="asc1229700463513__step_44D1B8735D5C42969B3572EFCE43E1F5"><a name="asc1229700463513__step_44D1B8735D5C42969B3572EFCE43E1F5"><!-- --></a> |
| <span>In the |
| <span class="uicontrol">Run</span> box, enter the SQL query, or click <span class="uicontrol">SQL</span> to graphically build the SQL statements in SQL Query Builder.</span> |
| </li> |
| |
| <li id="asc1229700463513__step_BD986E9DCA6E49D0B27130ABA5BF6FBD"><a name="asc1229700463513__step_BD986E9DCA6E49D0B27130ABA5BF6FBD"><!-- --></a> |
| <span>In the |
| <span class="uicontrol">Run</span> box, enter the SQL query, or click <span class="uicontrol">SQL</span>, select the statement type, and then complete building the SQL statement using Visual SQL.</span> |
| </li> |
| |
| <li id="asc1229700463513__step_827EBBB92C574FADBDC1430F9752D122"><a name="asc1229700463513__step_827EBBB92C574FADBDC1430F9752D122"><!-- --></a> |
| <span>Click |
| <span class="uicontrol">Run</span> to execute the query.</span> |
| </li> |
| |
| </ol> |
| |
| <div class="section" id="asc1229700463513__result_705F160D761F474A86CB4F43EEB23DF2"><a name="asc1229700463513__result_705F160D761F474A86CB4F43EEB23DF2"><!-- --></a>You can view the |
| results of the ad hoc query in the SQL Results view. |
| </div> |
| |
| </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/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> |
| </div> |
| <div/> |
| </body> |
| </html> |
