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

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF