Developing a Procedural Object

Use Database Development tools to create and update procedural objects.

Procedural objects include stored procedures, triggers, event handlers, and user-defined functions. 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 object
    Procedural 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 from source code in SQL File Editor, SQL Scrapbook, and the Source page of the procedural object editors.
  3. Running a Procedural Object Using a Launch Configuration
    Use the Eclipse launch configuration mechanism to run stored procedures, triggers, SQL Anywhere user-defined functions, and SQL Anywhere events. A Launch Configuration dialog guides you through running procedural objects.
  4. Viewing SQL Results
    Use the SQL Results view to see the results of an executed SQL query or procedural object.
  5. Debugging a Procedural Object
    Proceed with debugging once breakpoints have been set for a procedural object in the Database Development perspective.
Related concepts
Procedural Objects
Related reference
Database Development General Preferences

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.