![SET statement [T-SQL]](arrow-left.gif){kind=icon}
![SET DESCRIPTOR statement [ESQL]](arrow-right.gif){kind=icon}
Changes the active database connection.
SET CONNECTION [connection-name]
identifier, string or host-variable
In Embedded SQL:
EXEC SQL SET CONNECTION :conn_name
From dbisql, sets the current connection to the connection named “conn1”:
SET CONNECTION conn1
The current connection state is saved and is resumed when it again becomes the active connection. If connection-name is omitted and there is a connection that was not named, that connection becomes the active connection.
When cursors are opened in Embedded SQL, they are associated
with the current connection. When the connection is changed, the
cursor names are not accessible. The cursors remain active and in
position and become accessible when the associated connection becomes
active again.
None
None
