The CONNECT command will establish a connection to a database server. Subsequent procedure commands will run at the specified server. The running procedure's server will also be changed to the specified server. No immediate action is taken upon any other current objects within the procedure. However, subsequent commands which affect those objects may result in additional processing.
Assume query Q1 has been run but not completed at server X. The CONNECT TO 'SERVER Y' command is then issued, connecting to server Y. Next, the SAVE DATA AS T1 command is issued.
Query Q1 is not immediately affected by the CONNECT command to server Y, but the SAVE DATA command requires completion (or cancellation) of query Q1 at server X. Once the data object is completed, the server for query Q1 is changed to Y, and the data is saved in table T1 at server Y.
>>-- CONNECT TO ServerName ----------------------------------------------<<
Parameter | Description |
---|---|
ServerName | The name of a database server.
Note:
Enclose the server name in quotes if the name includes
spaces. |
CONNECT TO SERVER1