The SET CONNECTION statement sets the current connection within the list
of connected DBEnvironments. Any SQL statements issued apply to
the current connection.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
|
SET CONNECTION {'ConnectionName'
:HostVariable } |
Parameters |
|
- ConnectionName
is a string literal identifying the name associated
with this connection. This name must be unique for each DBEnvironment
connection within an application or an ISQL session. ConnectionName cannot exceed 128 bytes.
- HostVariable
is a character string host variable containing the
ConnectionName associated with this connection.
Description |
|
A connection to any
one of the list of connected DBEnvironments can be the current connection.
When the current connection is set from one DBEnvironment to another, any
previously connected DBEnvironment is said to be suspended.
If a previously suspended DBEnvironment connection
again becomes the current connection, all DBEnvironment context
information for the current connection is restored to the same state
as at the time when the DBEnvironment was suspended.
A connection with the DBEnvironment referenced in
this statement must have previously been established using either
a CONNECT, START DBE, START DBE NEW, or START DBE NEWLOG statement. This connection must not have been terminated
by a DISCONNECT, RELEASE, or STOP DBE statement.
No stored section is created for the SET CONNECTION statement. SET CONNECTION cannot be used with the PREPARE or EXECUTE IMMEDIATE statements or procedures.
An active transaction is not required to execute
a SET CONNECTION statement. An automatic transaction will not be started when executing a SET CONNECTION statement.
Authorization |
|
You do not need authorization to use the SET CONNECTION statement.
Example |
|
Establish two connections:
CONNECT TO :PartsDBE AS 'Parts1'
CONNECT TO :SalesDBE AS 'Sales1' |
At this point, Sales1 is the current connection.
Set the current connection to Parts1:
