|
|
The SET CONNECTION statement sets the current connection within the list
of connected DBEnvironments. Any SQL statements issued apply to
the current connection.
ISQL or Application Programs
SET CONNECTION {'ConnectionName'
:HostVariable }
- 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.
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.
You do not need authorization to use the SET CONNECTION statement.
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:
SET CONNECTION 'Parts1'
|