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

sp_servercaps system procedure

Displays information about a remote server's capabilities.

The server must be defined with the CREATE SERVER statement to use this system procedure.

sp_servercaps( @sname )

• @sname  Use this CHAR(64) parameter to specify a server defined with the CREATE SERVER statement. The specified @sname must be the same server name used in the CREATE SERVER statement.

This 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 forwarded to a remote server. The system tables that contain server capabilities (ISYSCAPABILITY and ISYSCAPABILITYNAME) are not populated until after SQL Anywhere first connects to the remote server.

• Sybase    Supported by Open Client/Open Server.

None

None

• SYSCAPABILITY system view
• SYSCAPABILITYNAME system view
• Accessing Remote Data
• Server Classes for Remote Data Access
• CREATE SERVER statement

To display information about the remote server testasa:

CALL sp_servercaps( 'testasa' );