DB2 graphic QMF Version 8

CONNECT command

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.

Example

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.

Syntax

>>-- CONNECT TO ServerName ----------------------------------------------<<

Parameters

Table 38. CONNECT Command Parameter
Parameter Description
ServerName The name of a database server.
Note:
Enclose the server name in quotes if the name includes spaces.

Example

CONNECT TO SERVER1


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004