Numeric Literals
Numeric literals specify numeric values. There are three types of numeric literals:
• Integer
• Decimal
• Floating-point
A numeric literal can be assigned to any of the numeric data types or the money data type without using an explicit conversion function. OpenSQL automatically converts the literal to the appropriate data type, if necessary.
By default, OpenSQL uses the period (.) to indicate the decimal when needed. This default can be changed by setting II_DECIMAL. For information about setting II_DECIMAL, see the Database Administrator Guide.
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: