Editing a Procedural Object

Edit a procedural object in its associated editor.

You can edit a procedural object to modify or add more SQL statements. You can add to the body of the procedural object either manually or by using Visual SQL or Content Assist.

  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 an existing procedural object.
    Procedural object Description
    Stored procedures Expand the Stored Procedures folder.
    SQL Anywhere or Sybase IQ User-defined functions Expand the User Defined Functions folder.
    Triggers Expand the Tables folder, select the table in which the trigger resides, and then expand the Triggers folder.
    SQL Anywhere or Sybase IQ events Expand the Events folder.
  3. Click the Source page to edit the procedural object.
    To Do this
    Edit manually Start typing.
    Use Visual SQL Create a new SQL select, insert, update or delete statement at the current cursor location. To access Visual SQL, right-click and select any of the SQL commands menu choices.
    Use Content Assist In the source code, press Ctrl+Space to display a list of syntax options available to you at the cursor point in your SQL code. Select the appropriate syntax to enter into the code by double-clicking it or by pressing Enter. Alternatively, an auto-invocation feature displays appropriate syntax lists when you pause after typing in certain characters, for example, '.', ',', '@'. These lists are more specific to the context and allow you to view, for example, a list of all table names in a database.
    Display line numbers Right-click in the left margin and select Show Line Numbers.
  4. Save the procedural object.
    To Do this
    Save the object to the same SQL file Select File > Save from the main menu.
    Save the object to a different SQL file and/or project Right-click and select Save As.
    Save the object to the database server Right-click and select Save to Database.
Related concepts
Procedural Objects
Related tasks
Creating a Procedural Object
Renaming a Procedural Object
Using Visual SQL

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com