Scalar Functions
There are six types of scalar functions:
• Data type conversion
• Numeric
• String
• Date
• Bitwise
• Random number
The scalar functions require either one or more single-value arguments. In most instances, scalar functions can be nested to any level. Certain restrictions apply when using some Enterprise Access products. For details, see the documentation provided with your Enterprise Access product.
Note: If II_DECIMAL is set to comma, be sure that when OpenSQL syntax requires a comma (such as a list of table columns or OpenSQL functions with several parameters), that the comma is followed by a space.
For example:
Select col1, ifnull(col2, 0), left(col4, 22) from t1: