ASA SQL User's Guide
Accessing Remote Data
Working with remote servers
The sp_servercaps procedure displays information about a remote server's capabilities. Adaptive Server 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 Adaptive Server Anywhere first connects to the remote server. This information comes from the SYSCAPABILITY and SYSCAPABILITYNAME system tables. The servername specified must be the same servername used in the CREATE SERVER statement.
Issue the stored procedure sp_servercaps as follows:
sp_servercaps servername
For more information, see sp_servercaps system procedure.