It is only when an Open Client application accesses Adaptive Server that the application must be aware of Adaptive Server restrictions. For example, Adaptive Server has login name requirements: the login name must follow the rules for Adaptive Server identifiers and it must be unique. When an Open Client application accesses an Adaptive Server, it must adhere to such requirements.
The Sybase SQL Server changed names to Adaptive Server
Enterprise at version level 11.5. The following restriction also
apply to SQL Server.
Following are some important Adaptive Server restrictions:
Dynamic SQL is implemented using temporary stored procedures, and therefore inherits the restrictions of stored procedures.
Long variable-length binary datatypes and long variable-length character datatypes are not supported.
By definition, a cursor is associated with only one select statement. This means that a stored procedure on which a Client-Library cursor is declared contains only a single statement: a select statement.
Stored procedures do not support parameters of datatype text or image.
Event notifications are not supported.
Message commands are not supported.
The POSIX locale method of localization is not supported.
