The initials "PSM" refer to the specifications of a document labelled "ISO/IEC 9075-4 Information Technology - Database Languages - SQL: Part 4: Persistent Stored Modules (SQL/PSM)".
-
About PSM
The initials "PSM" refer to the specifications of a document labelled "ISO/... -
Persistent Stored Modules
In SQL, the word "persistent" is applied to Schema Objects that survive ove... -
CREATE MODULE Statement
The CREATE MODULE statement creates an SQL-server Module: a Module that bel... -
ALTER MODULE Statement
The ALTER MODULE statement lets you change a Module's definition. The requi... -
DROP MODULE Statement
The DROP MODULE statement destroys an SQL-server Module. The required synta... -
BEGIN ... END: compound Statement
Advance warning: BEGIN ... END has several optional clauses. We are going t... -
SIGNAL Statement
The SIGNAL statement is used to clear the diagnostics area. The required sy... -
RESIGNAL Statement
The RESIGNAL statement is used to pass conditions on to another handler. Th... -
Program Control
Essential SQL has almost nothing that can control the program flow (except ... -
Should everything be in SQL?
PSM is an extension package which makes SQL3 a reasonably complete language... -
Dialects
PSM's features are vaguely similar to Oracle's PL/SQL, which also has: BEGI...