connect to server

Provides a pass-through mode that enables you to send commands to a server that is monitored by the RMS. The result sets generated by the commands are passed back to the client. You can connect to one server at a time to send commands.

Syntax

connect [to] server_name [username=username [,password = pwd]]

Parameters

server_name – Specifies the name of the server to which to connect.
username – An optional parameter that specifies a user name to use when connecting to the server. If you omit this parameter, the RMS uses the name used when the server was added.
pwd – The password associated with the user name.

Examples

Example 1 – Establishes a connection to the server INVENTORY_RS:
```
connect to INVENTORY_RS
```

Usage

Issuing the connect command establishes a connection to the server. The message Established a connection to the server server_name indicates the connection is established.
Subsequent commands are passed directly to the server until the client issues a disconnect command. Use ISQL commands appropriate for the server; for example, Transact-SQL for Adaptive Server Enterprise, or RCL for Replication Server.