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 ISYSCAPABILITY system table, which lists the server capabilities, is not populated until after SQL Anywhere first connects to a remote server.
Sybase Supported by Open Client/Open Server.
None
None
To display information about the remote server testasa:
CALL sp_servercaps( 'testasa' ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |