ECDA Option for ODBC and Adaptive Server System Procedures

System procedures are Sybase-supplied stored procedures that return information about the access service and the target database.

If the access service cannot support one of these procedures, the procedure returns a formatted result set containing zero rows.

Support Between ECDA System Procedures and Other Sybase Products
ECDA System Procedures	Support Relationship
sp_groups	Supported in ECDA Option for ODBC but not in Adaptive Server
sp_who	Supported only in ECDA Option for ODBC to Microsoft SQL Server datasources and ECDA Option for Oracle
sp_configure (read-only in ECDA Option for ODBC) sp_helpserver sp_sqlgetingo	Defined differently in ECDA Option for ODBC and Adaptive Server
sp_capabilities sp_thread_props	Defined in ECDA Option for Oracle to support Adaptive Server/CIS products
sp_char_length sp_datalength sp_password sp_patindex sp_textvalid	Not supported in ECDA Option for Oracle

sp_capabilities
Returns the SQL capabilities of an access service.
sp_configure
Provides a complete list of configuration names, minimum and maximum values, configured values, and current run values for each item.
sp_groups
Returns the current user name as the sole user group.
sp_helpserver
Returns help server information with the access service library details.
sp_sqlgetinfo
Provides information about SQL grammar, syntax, and capabilities that the target DBMS supports.
sp_thread_props
Allows the client to retrieve and set various thread properties.
sp_who
Reports information on current users and processes on Microsoft SQL Server.