Returns the SQL capabilities of a DB2 access service.
sp_capabilities
This procedure does not allow parameters.
The result set contains information that allows applications to successfully interact with a DB2 access service during normal query processing.
Table 12-1 shows the result set:
Column |
Datatype |
Description |
|---|---|---|
ID |
int |
Capability ID |
CAPABILITY_NAME |
char(30) |
Capability name |
VALUE |
int |
Capability value |
DESCRIPTION |
char(128) |
Capability description |
Table 12-2 shows the ID and values for several DB2 access service functional capabilities:
ID |
Capability |
Value description |
|---|---|---|
101 |
SQL syntax |
1=Sybase T-SQL supported 2=DB2 SQL supported |
102 |
Join handling |
0=Unsupported 1=No outer join supported 2=T-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=T-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=T-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 |
0=Unsupported 1=Supported |
118 |
String functions |
0=Unsupported 1=Substring supported 2=Oracle subset supported 3=T-SQL supported |
119 |
Expression handling |
0=Unsupported 1=ANSI supported 2=T-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=T-SQL DML without datetime in the where clause supported 2=T-SQL DML supported |
122 |
Date functions |
0=Unsupported 1=T-SQL date functions supported |
123 |
Math functions |
0=Unsupported 1=Oracle functions supported 2=T-SQL math functions supported |
124 |
T-SQL convert functions |
0=Unsupported 1=Supported |
125 |
T-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 |
132 |
tables per statement |
0=Unsupported 1=Supported |
133 |
Java UDF support |
0=Unsupported 1=Supported |
134 |
Java ADT support |
0=Unsupported 1=Supported |
135 |
Quoted Identifier support |
0=Unsupported 1=Supported |
137 |
SELECT-NULL support |
0=Unsupported 1=Supported |
138 |
Identity column support |
0=Unsupported 1=Supported |
