Chapter 12: Retrieving Information with System Procedures

ECDA Option for ODBC and ASE 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.

System procedures for ECDA Option for ODBC and their relationship with ASE and ASE/CIS are defined in the following sections.Table 12-1 shows a number of system procedures are either supported, not supported, or defined differently between ECDA Option for ODBC and ASE.

**Table 12-1: 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 ASE
sp_who	Supported only in ECDA Option for ODBC to Microsoft SQL Server data sources 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 ASE
sp_capabilities sp_thread_props	Defined in ECDA Option for Oracle to support ASE/CIS products
sp_char_length sp_datalength sp_password sp_patindex sp_textvalid	Not supported in ECDA Option for Oracle