| <?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 Stored Procedure"/> |
| <meta name="abstract" content="Run a stored procedure in the database using the Apache Derby connection."/> |
| <meta name="description" content="Run a stored procedure in the database using the Apache Derby connection."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700384901.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700390760.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700393698.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_Stored_Procedure.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="task_EB01ABD24F194D0FA236BFD684D418B0"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:26:32]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700392120"/> |
| <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 Stored Procedure</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700392120"><a name="asc1229700392120"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Running a Stored Procedure</h1> |
| |
| |
| |
| <div><p>Run a stored procedure in the database using the Apache Derby connection.</p> |
| |
| <a name="asc1229700392120__steps_F337AD327D8B4CC0BB4A202F9EBA63F7"><!-- --></a><ol id="asc1229700392120__steps_F337AD327D8B4CC0BB4A202F9EBA63F7"> |
| <li class="stepexpand" id="asc1229700392120__step_3DCE5E0909BB4011B81F044A92F95909"><a name="asc1229700392120__step_3DCE5E0909BB4011B81F044A92F95909"><!-- --></a> |
| <span>From Data Source Explorer, under Databases, expand the Derby Embedded connection profile tree.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700392120__step_829A123B92464ED285C4275A81ED66A2"><a name="asc1229700392120__step_829A123B92464ED285C4275A81ED66A2"><!-- --></a> |
| <span>Under the appropriate database, expand the <span class="uicontrol">SYSIBM</span> schema, then expand <span class="uicontrol">Stored Procedures</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700392120__step_2240B85049BD4B619966B9AA44FE23A7"><a name="asc1229700392120__step_2240B85049BD4B619966B9AA44FE23A7"><!-- --></a> |
| <span>Right-click the stored procedure that you want to run and select <span class="uicontrol">Run</span>.</span> |
| |
| <p>The stored procedure opens in an editor window.</p> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700392120__step_FAB24134BD2C452B9C7C042E8974A639"><a name="asc1229700392120__step_FAB24134BD2C452B9C7C042E8974A639"><!-- --></a> |
| <span>(Optional) In the <span class="uicontrol">Configure Parameters</span> dialog, change the default values as necessary and click <span class="uicontrol">OK</span>.</span> |
| |
| <p>The stored procedure executes, and the output displays in the SQL Results view.</p> |
| |
| |
| </li> |
| |
| </ol> |
| |
| </div> |
| |
| <div> |
| <div class="familylinks"> |
| <div class="parentlink"><strong>Parent topic:</strong> <a href="../../doc/html/asc1229700384901.html" title="Use the tutorial to get started using the Data Tools Platform with Apache Derby.">Data Tools Platform Tutorial Overview</a></div> |
| <div class="previouslink"><strong>Previous topic:</strong> <a href="../../doc/html/asc1229700390760.html" title="Connect to an Apache Derby database from the Data Source Explorer.">Connecting to Apache Derby</a></div> |
| <div class="nextlink"><strong>Next topic:</strong> <a href="../../doc/html/asc1229700393698.html" title="Create a SQL file and run it against a given database instance.">Creating and Executing a SQL Query</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |
