| <?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 a Routine Object"/> |
| <meta name="abstract" content="Run a routine object to obtain SQL results from the database."/> |
| <meta name="description" content="Run a routine object to obtain SQL results from the database."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700470998.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700480170.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700478717.html"/> |
| <meta name="DC.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\dtp\dtp\en\source\t_running_a_routine_object.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="task_7C1AD234ABCD48B7925603772B9063D8"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:27:47]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700467920"/> |
| <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 a Routine Object</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700467920"><a name="asc1229700467920"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Running a Routine Object</h1> |
| |
| |
| |
| <div><p>Run a routine object to obtain SQL results |
| from the database. |
| |
| |
| |
| </p> |
| |
| <div class="p" id="asc1229700467920__prereq_E945045DB7DB4B2EB987B90CBC2A53B4"><a name="asc1229700467920__prereq_E945045DB7DB4B2EB987B90CBC2A53B4"><!-- --></a><strong class="prereq-title">Prerequisites </strong> |
| <p>Connect to your database server through a connection profile. Save or deploy the routine object to a database. |
| |
| </p> |
| |
| </div> |
| |
| <a name="asc1229700467920__steps_CD8A973D576B425CA698EAF75CBBEE75"><!-- --></a><ol id="asc1229700467920__steps_CD8A973D576B425CA698EAF75CBBEE75"> |
| <li class="stepexpand" id="asc1229700467920__step_A4857B248A1D4F1FBAD33F0051FE95C4"><a name="asc1229700467920__step_A4857B248A1D4F1FBAD33F0051FE95C4"><!-- --></a> |
| <span>In Data Source Explorer, find the routine object in the navigation tree.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700467920__step_52C97FAD4EA94E46973F280001A6CB48"><a name="asc1229700467920__step_52C97FAD4EA94E46973F280001A6CB48"><!-- --></a> |
| <span>Right-click the object and select |
| <span class="uicontrol">Run</span>.</span> |
| |
| <div class="note"><span class="notetitle">Note:</span> If the object includes parameters, the Configure Parameters dialog appears. |
| Edit parameter values as necessary. </div> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700467920__step_7325760645B34B9CB833836A296F32FE"><a name="asc1229700467920__step_7325760645B34B9CB833836A296F32FE"><!-- --></a> |
| <span>Click |
| <span class="uicontrol">OK</span> to run the object. |
| |
| </span> |
| |
| <p>The SQL Results view displays the status of the run |
| instance and execution details, and returns result sets and server messages, |
| if any. |
| </p> |
| |
| |
| </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> |
| <div class="reltasks"><strong>Related tasks</strong><br/> |
| <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/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> |
