Icon Introduction

SQL/PSM (persistent stored module) statements are used to define stored functions and procedures that are stored in an ElevateDB database and can be called from both client code and other stored functions and procedures. This section of the manual details the available SQL/PSM statements in ElevateDB.

The notation used in the syntax section for each SQL/PSM statement is as follows:

<Element>Specifies an element of the statement that may be expanded upon further on in the syntax section
<Element> = Describes an element specified earlier in the syntax section
[Optional Element]Describes an optional element by enclosing it in square brackets []
Element|ElementDescribes multiple elements, of which one and only one may be used in the syntax