Developing Procedural Objects

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

Procedural objects include:

Stored procedures
Triggers
Event handlers (Adaptive Server Anywhere and Sybase IQ only)
User-defined functions (Adaptive Server Anywhere and Sybase IQ only)

The basic workflow for developing procedural objects includes:

Completing the Setup for Database Development
(Optional) Creating a Simple Database
Creating a procedural object: When you create a procedural object, you launch a wizard in which you enter the basic information about the SQL object, such as Name, SQL dialect type, and Comments. As you complete this information, the wizard dynamically generates the appropriate SQL code and displays it in the Preview window. Once you click Finish, the end result is a procedural object definition skeleton, which you can then edit.
Editing a Procedural Object
Saving a Procedural Object Definition to a Database
or Saving a Procedural Object Definition as a SQL File
Running a Procedural Object
Debugging a Procedural Object

Creating an ASA Stored Procedure

Creating an ASE Stored Procedure

Creating an ASE Trigger

Creating an ASA Trigger

Creating an ASA Event Handler

Creating an ASA User-Defined Function

Creating a Procedural Object from a SQL File

Learn More About Procedural Objects