sp_capabilities

ID

int

Capability ID

CAPABILITY_NAME

char(30)

Capability name

VALUE

int

Capability value

DESCRIPTION

char(128)

Capability description

101

SQL syntax

• 1 = Sybase supported

• 2 = DB2 UDB supported

102

join handling

• 0 = unsupported

• 1 = all but outer join supported

• 2 = full join supported

103

aggregate handling

• 0 = unsupported

• 1 = count not 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 supported

• 2 = Sybase supported

107

bulk insert handling

• 0 = unsupported

• 1 = supported

108

text/image handling

• 0 = unsupported

• 1 = text without textptr supported

• 2 = text with textptr supported

109

transaction handling

• 0 = unsupported

• 1 = local supported

• 2 = two-phase-commit supported

110

text pattern handling

• 0 = unsupported

• 1 =supported

111

order by

• 0 = unsupported

• 1 = supported

112

group by

• 0 = unsupported

• 1 = 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

• Anything else is the escape character

117

union handling

• 0 = unsupported

• 1 = supported

118

string functions

• 0 = unsupported

• 1 = substring supported

• 2 = Oracle subset supported

• 3 = all TransacTransact-SQL supported

119

expression handling

• 0 = unsupported

• 1 = supported

• 2 = full Transact-SQL supported

120

truncate trailing spaces on varchar parameters

• 0 =no

• 1 = yes

121

language events

• 0 = no support for DML

• 1 = DML support without datetime in where clause

• 2 = no restrictions on DML

122

date functions

• 0 = unsupported

• 1 = all Transact-SQL supported

123

math functions

• 0 = unsupported

• 1 = Oracle subset supported

• 2 = all Transact-SQL supported

124

Transact-SQL convert function

• 0 = unsupported

• 1 = supported

125

Transact-SQL delete/update

• 0 = unsupported

• 1 = Transact-SQL extensions supported

126

insert/update handling

• 0 = unsupported

• 1 = supported

127

subquery handling

• 0 = unsupported

• 1 = supported

128

in/not in clause

• 0 = unsupported

• 1 = supported

129

case expression in a SQL statement

• 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