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 = not case sensitive

• 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 Transact-SQL supported

119

Expression handling

• 0 = unsupported

• 1 = supported

• 2 = full Transact-SQL supported

120

Truncate trailing spaces on varchar/char CSP 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