Was this helpful?
Mapping OpenSQL Functions to Host Functions
The following tables contain lists of the OpenSQL functions, support level, and a comment when the function mapping is restricted. Possible values for the Support column include:
RESTRICT
Indicates that the function is supported but with restrictions. The restriction may be as simple as requiring a literal value for a parameter, or it may indicate a slight variation from the standard OpenSQL behavior for the function.
COMPAT
Indicates the existence of a native DBMS function that exactly matches the OpenSQL function. No translation is performed for those functions listed as COMPAT.
TRANS
Indicates that the function is translated to the target DBMS SQL with no restrictions.
NO
Indicates that a function is not supported.
Last modified date: 08/22/2022