LEAVE (PROGRAM ident)

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

leave_program_ident.png

 

Usage

Embedded/Interactive/Module/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;

Standard Compliance

Standard

Compliance

Comments

 

Mimer SQL extension

The LEAVE (program) statement is a Mimer SQL extension.