When you first open Run SQL Scripts from the tree view, you are automatically connected to the database that you came from. You can connect to an additional system in Run SQL Scripts by running the CONNECT statement within the script area. However, this database must be registered in the relational database directory on this database, because this connection will be made as a DRDA connection.
You can also connect to a different system through the Run SQL Scripts interface. See Connect to a different database for more information.
Execute SQL statements at NEWYORK and LONDON. The first CONNECT statement creates the NEWYORK connection and the second CONNECT statement places it in the dormant state.
CONNECT TO NEWYORK;
(execute statements referencing objects at NEWYORK)
CONNECT TO LONDON;
(execute statements referencing objects at LONDON)
For more information, see CONNECT (TYPE 1) or CONNECT (TYPE 2) in the SQL Reference topic in the Information Center
.