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 (ASA/ASIQ only)
User-defined functions (ASA/ASIQ only)

The basic workflow for developing procedural objects includes:

Creating a procedural object: When you create a procedural object, you launch a wizard in which you enter the basic SQL code, such as Name, SQL dialect, and Comments. As you complete these parameters, the wizard dynamically generates the appropriate SQL code and displays it in the Preview window. Once you click Finish, the end result is a SQL code file that represents the skeleton of your stored procedure, 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

Learn More About Procedural Objects