The SET CONNECTION statement establishes the current server of the activation group by identifying one of its existing connections.
Execute SQL statements at NEWYORK, execute SQL statements at LONDON, and then execute more SQL statements at TOROLAB1.
CONNECT TO NEWYORK;
(Execute statements referencing objects at NEWYORK)
CONNECT TO LONDON;
(Execute statements referencing objects at LONDON)
SET CONNECTION NEWYORK;
(Execute statements referencing objects at NEWYORK)
The first CONNECT statement creates the NEWYORK connection, the second CONNECT statement places it in the dormant state, and the SET CONNECTION statement returns it to the current state.
For more information, see SET CONNECTION in the SQL Reference topic in the
Information Center.