LEAVE (PROGRAM ident)
PROGRAMident and restores the state of the previous ident.
PROGRAMident is left and the saved environment of the previous ident is restored.
RETAINis 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.
LEAVEstatement may not be issued within a transaction.
ExampleENTER 'program_name' USING 'secret'; LEAVE RETAIN;
For more information, see the Mimer SQL User's Manual, PROGRAM Idents - ENTER and LEAVE.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40