CONNECT command stablishes a connection
to a database data source.
assume query Q1 has been run but not completed at server X. The
TO 'SERVER Y' command is then issued, connecting to server
Y. Next, the
SAVE DATA AS T1 command is issued.
Q1 is not immediately affected by the
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 ------------------------<< +- UserName -+ (PASSWORD=password
|ServerName||The name of a database server. If the name includes spaces, enclose it in quotes.|
|UserName||The user name that will be used to connect to the database server. UserName is an optional parameter.|
|PASSWORD||The password that will be used to connect to the database server. If you specify UserName, you must supply a password using the PASSWORD parameter.|
CONNECT TO SERVER1
CONNECT pjones TO SERVER1 (PASSWORD=sales