7. Understanding Database Procedures, Sessions, and Events : Multiple Session Connections : Session Switching
 
Share this page                  
Session Switching
To switch sessions using a numeric session identifier, use the SET_SQL(SESSION) statement. To switch sessions using the connection name, use the SET CONNECTION statement.
To determine the numeric session identifier for the current session, use the INQUIRE_SQL(SESSION) statement. To determine the connection name for the current session, use the INQUIRE_SQL(CONNECTION_NAME) statement.
Applications can switch sessions in the following circumstances:
Within a transaction
While cursors are open
Within SQL block statements, such as a select loop
The program code for the nested session must be inside a host language subroutine. If it is not, the SQL preprocessor issues an error.
Within subroutines called by a WHENEVER statement
Within the following types of routines:
Data handlers (for long varchar or long byte data)
Error handlers
Message handlers
Database event handlers
Note:  Sessions cannot be switched inside a database procedure.
After an application switches sessions, the error information obtained from the SQLCA or the INQUIRE_SQL statement is not updated until an SQL statement has completed in the new session.