System procedures in DirectConnect and Adaptive Server

System procedures for DirectConnect and their relationship with Adaptive Server and ASE/CIS are defined in the following sections. A number of system procedures are either supported, not-supported, or defined differently between DirectConnect and Adaptive Server:

Supported in DirectConnect and not in Adaptive Server

Following is a system procedure that is supported in DirectConnect, but not supported in Adaptive Server:

sp_groups

Defined differently in DirectConnect and Adaptive Server

Following are system procedures defined differently in DirectConnect and Adaptive Server:

sp_configure (read only in DirectConnect)
sp_helpserver
sp_sqlgetingo

Defined in DirectConnect for ASE/CIS

Following are system procedures defined in DirectConnect to support ASE/CIS products:

sp_capabilities
sp_thread_props

Not supported in DirectConnect

Following are system procedures that are not supported in DirectConnect:

sp_char_length
sp_datalength
sp_password
sp_patindex
sp_textvalid
sp_who