![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
The following example is in Embedded SQL:
EXEC SQL SET CONNECTION :conn_name;
From DBISQL, set the current connection to the connection named conn1:
SET CONNECTION conn1 ;
The SET CONNECTION statement changes the active database connection to connection-name. The current connection state is saved and will be 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 will not be accessible. The cursors remain active and
in position and will become accessible when the associated connection
becomes active again.
None.
None.
