Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Procedural Programming using SQL

The Altibase PSM (Persistent Stored ModuleThe ALTIBASE Stored Procedure (ALTIBASE PSM) provides control flow statements and exception handlers so that procedural programming can be conducted using SQL statements.

...

Because stored procedures reside in the database server, when business logic changes, only the stored procedures procedure need to be changed, there is no need to update client programs distributed among multiple machine.

Sharing and Productivity

Stored procedures are procedure is stored in the database, which means that one user can execute another user's stored procedures, as long as a user has been granted proper access privileges.

Moreover, because stored procedures procedure can be called from within other stored procedures, when the need arises for a new business process that is based on an existing business process,

...