Stored procedures and triggers expand the flexibility and performance of applications that access the OpenEdge SQL environment. They provide a mechanism for storing a collection of SQL statements and Java program constructs that enforce business rules and perform administrative tasks in a database.
Stored procedures and triggers enhance applications by:
Enabling a client application to perform a procedure with a single request instead of multiple requests for each SQL statement.
Executing faster than a corresponding SQL script.
Implementing elaborate algorithms to enforce complex business rules. The details of the procedure implementation can change without requiring changes in an application that calls the procedure.
Enabling a client application to perform a procedure with a single request instead of multiple requests for each SQL statement.