sp_capabilities

Description

Returns the SQL capabilities of an access service.

Syntax

sp_capabilities

Parameters

None.: This procedure does not allow parameters.

Usage

The result set contains information that allows applications to successfully interact with an access service during normal query processing.
For information about the requirements for sp_capabilities, see the Component Integration Services Users Guide Adaptive Server Enterprise.

Table 12-2 shows the result set:

**Table 12-2: Result set for sp_capabilities**
Column	Datatype	Description
ID	int	Capability ID
CAPABILITY_NAME	char(30)	Capability name
VALUE	int	Capability value
DESCRIPTION	char(128)	Capability description

Table 12-3 shows values for the capabilities:

**Table 12-3: Values for sp_capabilities**
Capability number	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