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 an DB2 access service during normal query processing.
The following table 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 |
The following table 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 |
Wild card 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 |
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
