Mimer SQL Programmer's Manual TOC PREV NEXT INDEX

Mimer Developer Site


Persistent Stored Modules

It is possible to define and store routines in Mimer SQL. A number of routines may be collected together into a module. This chapter describes stored routines and modules, together referred to as Persistent Stored Modules (SQL/PSM).

SQL/PSM consists of syntax and semantics for variable and cursor declarations, assignment of the results of expressions to variables and parameters, conditional statements, control statements for looping and branching, condition handling, get diagnostics for status information and routine invocations.

You can debug your routines using Mimer SQL's Java-based graphic debugger for PSM routines. The debugger has support for watching variables, step-wise execution and setting breakpoints. You can debug procedures, functions and triggers. For more information, see The Mimer SQL PSM Debugger.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL Programmer's Manual TOC PREV NEXT INDEX