Displays information about a remote server's capabilities.

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

Syntax

sp_servercaps( @sname )

Arguments

Remarks

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 ISYSCAPABILITY system table, which lists the server capabilities, is not populated until after SQL Anywhere first connects to a remote server.

Standards and compatibility

Permissions

None

Side effects

None

See also

• SYSCAPABILITY system view
• SYSCAPABILITYNAME system view
• Accessing remote data
• Server classes for remote data access
• CREATE SERVER statement

Example

To display information about the remote server testasa:

CALL sp_servercaps( 'testasa' );