SET CONNECTION statement [Interactive SQL][ESQL]
610
SET CONNECTION statement
[Interactive SQL][ESQL]
Use this statement to change the active database connection.
SET CONNECTION [
connection-name
]
connection-name
:
identifier
,
string,
or
host-variable
None.
None.
"CONNECT statement" on page 423
"DISCONNECT statement" on page 504
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 of the
previously active connection become inaccessible. These cursors remain
active and in position, and become accessible when the associated
connection becomes active again.
♦
SQL/92 Interactive SQL use is a vendor extension. Embedded SQL is
a Full level feature.
♦
Sybase Supported by Open Client/Open Server.
♦ The following example is in Embedded SQL.
EXEC SQL SET CONNECTION :conn_name;
♦ From Interactive SQL, set the current connection to the connection
named conn1.
SET CONNECTION conn1;
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example
To Next Page
Loading...