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.
See”List remote server capabilities” in SQL Anywhere Server - SQL Usage.
See also sp_servercaps system procedure in Reference: Building Blocks, Tables, and Procedures.
