Viewing or Modifying Remote Server Properties

Display or change the properties of the selected remote server definition.

Prerequisites

Database Version	Remote Server Privileges
SAP Sybase IQ 15.3 and 15.4	View remote server properties – None required. Modify remote server properties – Requires DBA authority.
SAP Sybase IQ 16.0	View any remote server property page – None required. Modify any remote server property – Requires SERVER OPERATOR system privilege.

Database Version

Remote Server Privileges

SAP Sybase IQ 15.3 and 15.4

View remote server properties – None required.

Modify remote server properties – Requires DBA authority.

SAP Sybase IQ 16.0

View any remote server property page – None required.

Modify any remote server property – Requires SERVER OPERATOR system privilege.

The SAP Sybase IQ resource is authenticated and running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Networks > Remote Servers.
Select the remote server from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties
The Remote Server Properties view appears.

View the properties, including the defined proxy tables, remote procedures and external logins associated with the remote server, by navigating to the corresponding page on the Remote Server Properties view. On any page, by selecting a proxy table, remote procedure, or external login and clicking the corresponding button, you can Edit, Delete, Generate DDL or View Data in SQL.

When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.

Area	Description
General	Name – (Read-only) The local name used for connecting to the server where the remote database is located, as specified when the remote server was created. Read-Only – (Read-only) Indicates whether the remote server is a read-only data source, as specified when the remote server was created. Server Type – The type of server where the remote database is located. Connection Type – The Remote Server Type you specify may limit the connection type. The only server types allowing a JDBC connection are Sybase IQ, SQL Anywhere and Sybase ASE servers. However, for IQ server versions 16.0 and above, JDBC is not supported. Connection Information – Use the Test Connection button to validate the connection information.
Proxy tables	Name – The local name used for the object on the remote database Owner – The specified user ID owning the object. Location – The server on which the remote database resides. Comment – Additional description or information.
Remote procedures	Name – The local name used for the procedure on the remote database Owner – The specified user ID owning the procedure. Comment – Additional description or information
External logins	User – The defined local user for whom the alternate login name and password (external login) was created Login Name – The user ID used on the remote server by the User.

Click OK.