Once you finish editing a procedural object (stored procedure, trigger, ASA/ASIQ event handler, and user-defined function) to your satisfaction, you are ready to deploy (or save) its definition to a database. You can save the modified procedural object definition into a SQL file if you are not yet ready to save the definition to the database. There are two ways to save a procedural object definition to a database.
To save a procedural object definition to a database:
Right-click inside SQL Editor and select Save to Database from the context menu. The procedural object definition is deployed to the database.
With your procedural object's SQL code visible in SQL Editor, click the toolbar's
button.