Remote server capabilities

The first time Adaptive Server establishes a connection to a remote server of class sds or direct_connect, it issues an RPC named sp_capabilities and expects a set of results in return. This result set describes functional capabilities of the remote server so that Component Integration Services can adjust its interaction with that remote server to take advantage of available features. Component Integration Services forwards as much syntax as possible to a remote server, according to its capabilities.

For servers in other classes, CIS sets remote server capabilities for the remote server based on a set of assumptions. For example, server class db2 inherits a set of assumptions based on known capabilities of IBM’s DB2 database management system. For server class ASEnterprise, capabilities are established based on the version of ASE represented by the remote server.