It is only when an Open Client application accesses Adaptive Server Enterprise that the application must be aware of Adaptive Server Enterprise restrictions. For example, Adaptive Server Enterprise has login name requirements: the login name must follow the rules for Adaptive Server Enterprise identifiers and it must be unique. When an Open Client application accesses an Adaptive Server Enterprise, it must adhere to such requirements.
Following are some important Adaptive Server Enterprise 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 may not support parameters of certain datatypes. See the documentation for Adaptive Server Enterprise for information about restrictions on stored procedure parameters.
Event notifications are not supported.
Message commands are not supported.
The POSIX locale method of localization is not supported.
