RESUME SESSION

The RESUME SESSION management statement resumes a suspended SQL session. You use the RESUME SESSION statement primarily in pseudo conversational programming. It is also a CA IDMS extension of the SQL standard.

Authorization

None required.

Syntax

►►─── RESUME SESSION ─────────────────────────────────────────────────────────►◄

Usage

Effect of RESUME SESSION

When you resume an SQL session, CA IDMS re-establishes the session as it existed immediately before it was suspended.

Resuming a Suspended Session

The following RESUME SESSION statement resumes the current suspended SQL session:

EXEC SQL
   RESUME SESSION
END-EXEC

More Information

For more information about suspending an SQL session, see SUSPEND SESSION.
For more information about managing SQL sessions, see the CA IDMS SQL Programming Guide.