SQL Programming Techniques › Pseudoconversational Programming › Using SUSPEND SESSION and RESUME SESSION

Using SUSPEND SESSION and RESUME SESSION

What SUSPEND SESSION Does

When the program issues a SUSPEND SESSION statement, the DBMS releases all resources associated with the SQL session except those needed to resume the current session and transaction:

• The database connection
• Cursor currencies
• Locks held by any currently active transaction
• Temporary tables
• Dynamically prepared SQL statements

SUSPEND SESSION does not cause a commit or rollback of work.

What RESUME SESSION Does

RESUME SESSION reestablishes the active SQL session and database transaction. All characteristics and cursor positions of the session and transaction are restored to what they were when the program issued the SUSPEND SESSION statement.

In a pseudoconversational program, RESUME SESSION must be the first SQL statement the application issues after a SUSPEND SESSION statement.

Advantages of Suspending and Resuming

Since a suspended session preserves database transaction and SQL session characteristics, you can use SUSPEND SESSION and RESUME SESSION in these types of applications:

• Scrolling through a list of result rows
• Updating a row with user input

The following sections discuss how to use SUSPEND SESSION and RESUME SESSION in these types of processing.