
520 Chapter12
SQL Statements S - Z
SET CONNECTION
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:
SET CONNECTION 'Parts1'