Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Working with remote servers

Listing the remote tables on a server Next Page

Listing remote server capabilities

The sp_servercaps system procedure displays information about a remote server's capabilities. SQL Anywhere uses this capability information to determine how much of a SQL statement can be passed off to a remote server.

The system tables which contain server capabilities are not populated until after SQL Anywhere first connects to the remote server. This information comes from the ISYSCAPABILITY and ISYSCAPABILITYNAME system tables. The server-name specified must be the same server-name used in the CREATE SERVER statement.

Execute the stored procedure sp_servercaps as follows:

CALL sp_servercaps  server-name;
See also