Developing a Procedural Object

Use Database Development tools to create and update procedural objects, which include stored procedures, triggers, user-defined functions, and event handlers.

Procedural objects are the building blocks of your database application. Database Development assists you in building the shell, or skeleton, for procedural objects and provides tools for filling in the body of the object with the appropriate SQL syntax.

  1. Creating a Procedural Routine Object
    Procedural Routine objects standardize actions performed by more than one application program.
  2. Using Visual SQL
    Use Visual SQL to create select, insert, update, and delete statements.
  3. Running a Procedural Routine Object Using a Launch Configuration
    Create a launch configuration to guide you through running stored procedures, user-defined functions, events, and triggers. You can save the launch configuration to the Run and/or Debug menus, so you can quickly and easily run this object again.
  4. Viewing SQL Results
    Use the SQL Results view to see the results of an executed SQL query or routine procedural object.
  5. Debugging a Procedural Object
    You can debug a procedural object after you set breakpoints.
Related concepts
Procedural Routine Objects
Related reference
Database Development General Preferences

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