Switching Sessions
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 statement, use the inquire_sql(connection_name) statement.
Note: After an application switches sessions, the error information obtained from the inquire_sql statement is not updated until an SQL statement has completed in the new session.
Last modified date: 01/30/2023