Returns the SQL capabilities of the server.
sp_capabilities
This procedure does not use or allow parameters.
The result set contains information that allows applications to successfully interact with the server during normal query processing.
The following table shows the result set:
Column name |
Datatype |
Description |
|---|---|---|
ID |
int |
Capability ID |
CAPABILITY_NAME |
char(30) |
Capability name |
VALUE |
int |
Capability value |
DESCRIPTION |
char(128) |
Capability description |
The following table shows values for the capabilities.
ID |
Capability |
Value description |
|---|---|---|
101 |
SQL syntax |
1=Sybase Transact-SQL® supported 2=DB2 SQL supported |
102 |
Join handling |
0=Unsupported 1=No outer join supported 2=Transact-SQL support 3=Oracle supported |
103 |
Aggregate handling |
0=Unsupported 1=ANSI supported 2=All functions |
104 |
AND predicates |
0=Unsupported 1=Supported |
105 |
OR predicates |
0=Unsupported 1=Supported |
106 |
LIKE predicates |
0=Unsupported 1=ANSI-style supported 2=Transact-SQL supported |
107 |
Bulk insert handling |
0=Unsupported 1=Supported |
108 |
Text and image handling |
0=Unsupported 1=Text, no textptr 2=Text and textptr |
109 |
Transaction handling |
0=Unsupported 1=Local supported 2=Two-phase commit supported |
110 |
Text pattern handling |
0=Unsupported 1=Pattern (text) supported |
111 |
order by |
0=Unsupported 1=Supported |
112 |
group by |
0=Unsupported 1=ANSI supported 2=Transact-SQL supported |
113 |
Net password encryption |
0=Unsupported 1=Supported |
114 |
Object case sensitivity |
0=Case insensitive 1=Case sensitive |
115 |
distinct |
0=Unsupported 1=Supported |
116 |
Wildcard escape |
0=Unsupported Non-zero=Escape_char(s) |
117 |
Union handling |
=Unsupported 1=Supported |
118 |
String functions |
0=Unsupported 1=Substring supported 2=Oracle subset supported 3=Transact-SQL supported |
119 |
Expression handling |
0=Unsupported 1=ANSI supported 2=Transact-SQL supported |
120 |
Character truncation |
0=Fixed length character parameters may contain trailing blanks 1=Fixed length character parameters will not contain trailing blanks |
121 |
Language events |
0=Unsupported 1=Transact-SQL DML without datetime in the where clause supported 2=Transact-SQL DML supported |
122 |
Date functions |
0=Unsupported 1=Transact-SQL date functions supported |
123 |
Math functions |
0=Unsupported 1=Oracle functions supported 2=Transact-SQL math functions supported |
124 |
Transact-SQL convert functions |
0=Unsupported 1=Supported |
125 |
Transact-SQL delete/update |
0=Sybase extensions not supported 1=Sybase extensions supported |
126 |
Insert/select handling |
0=Unsupported 1=Supported |
127 |
Subquery handling |
0=Unsupported 1=Supported |
128 |
IN/NOT IN support |
0=Unsupported 1=Supported |
129 |
CASE support |
0=Unsupported 1=Supported |
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
