Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


LEAVE (PROGRAM ident)


Leaves a PROGRAM ident and restores the state of the previous ident.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

The current PROGRAM ident is left and the saved environment of the previous ident is restored.

If RETAIN is specified, resources allocated to the ident being left are kept, i.e. cursor declarations. The cursors are however inactivated, and may not be used in any statement until the same ident is re-entered.

Restrictions

The LEAVE statement may not be issued within a transaction.

Example

 ENTER 'program_name' USING 'secret';
 LEAVE RETAIN;
 

For more information, see the Mimer SQL User's Manual, chapter 4, PROGRAM Idents - ENTER and LEAVE.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
MIMER EXTENSION
Support for PROGRAM idents is a Mimer SQL extension.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX