Running a Procedural Object

Run a procedural object to obtain SQL results from the database.

Prerequisites 

Before you can run a procedural object, save or deploy it to a database. If procedural objects are modified in an editor, a dialog displays to prompt you to save to the database server before running.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Find the procedural object under the schema owner and database, right-click it, and choose Run.
    Note: If the procedural object includes parameters, the Configure Parameters dialog appears. You can alter parameter values from here.
  3. Click OK to run the procedure.

    The SQL Results view displays the status of the run instance, the execution details, and returns result sets and server messages, if any.

Related tasks
Running a Procedural Routine Object Using a Launch Configuration
Creating a Launch Configuration for Routine Procedural Objects
Running a Stored Procedure
Running a User-Defined Function
Running a Trigger
Running a SQL Anywhere or Sybase IQ Event
Viewing SQL Results

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com