The sp_servercaps procedure displays information about a remote server's capabilities. Sybase IQ uses this capability information to determine how much of a SQL statement can be passed to a remote server.
The system tables that contain server capabilities are not populated until after Sybase IQ 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.
Run the stored procedure sp_servercaps as follows:
sp_servercaps servername
For more information, see the sp_servercaps system procedure in Sybase IQ Reference Manual.
