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 servername

None.

This 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 forwarded to a remote server. The system tables which contain server capabilities are not populated until after Sybase IQ first connects to the remote server. This information comes from syscapability and syscapabilityname system tables. The servername specified must be the same server name used in the CREATE SERVER statement.

• To display information about the remote server testiq issue the following stored procedure (output has been truncated):

  sp_servercaps testiq
  

  1,’Alter table with add’,’T’
  2,’Alter table with drop’,’T’
  3,’Owner supported’,’T’
  4,’Primary key requires index’,’F’
  5,’Create table constraints’,’T’
  6,’Truncate table’,’T’
  7,’Create index’,’T’ 7,’Create index’,’T’
  8,’Create unique index’,’T’
  9,’Syscapability system table initialized’,’T’
  10,’Subquery’,’T’
  11,’Subquery in group by’,’T’
  12,’Subquery in comparison’,’T’
  13,’Subquery in exist’,’T’
  14,’Subquery in IN’,’T’
  15,’Subquery correlated’,’T’
  16,’Subquery in select list’,’T’
  17,’Subquery in update’,’T’
  20,’Order by’,’T’
  21,’Order by expressions’,’T’
  22,’Order by column not in select list’,’T’
  23,’Order by allowed in update’,’T’
  25,’Joins’,’T’
  26,’Outer joins’,’T’
  27,’Full outer joins’,’T’
  28,’Multiple outer joins’,’T’
  29,’Logical operators in outer join’,’T’
  30,’Outer joins mixed with normal joins’,’T’
  31,’ANSI join syntax’,’T’
  32,’TSQL join syntax’,’F’
  33,’ODBC outer join syntax’,’F’
  34,’Unrestricted ANSI ON’,’T’
  40,’Group by’,’T’
  41,’Group by ALL’,’T’
  45,’Aggregates’,’T’
  46,’Aggregates with column name’,’T’
  50,’And’,’T’
  51,’Or’,’T’
  52,’Like’,’T’
  53,’Like - TSQL’,’T’
  54,’Distinct’,’T’
  55,’In’,’T’