You can use a literal as a value expression. A literal is either a character string or a numeric literal. Numeric literals can take the following forms: o A decimal string consisting of digits and an optional decimal point. The maximum length, not counting the decimal point, is 19 digits. o A decimal number in scientific notation (E-format), consisting of a decimal string mantissa and a signed integer exponent, separated by the letter D (for double), E (for E-format) or Q (for H_floating). CDO allows you to use unary plus and minus signs in numeric literals. Numeric literals must start and end with a numeral and cannot include hexadecimal digits. Numeric literals in E notation cannot include embedded spaces. The following expressions are valid numeric literals: +123 -3.49 0.3338889909 6.03 E+23 If you use a numeric literal to assign a value to a field or a variable, the data types of the field or variable determine the maximum value you can assign. A period at the end of a data definition command line terminates the command; therefore, you cannot use a decimal point to terminate a number if you want to include more data definition clauses in the statement. If you want to include more data definition clauses, include a zero after the decimal point, or place the value expression in parentheses: COMPUTED BY X * 2.0 COMPUTED BY (X * 2.)
1 – Examples
S IN SALARY_HISTORY WITH SALARY_AMOUNT IN S > 40000 In this example, the expression specifies the numeric literal 40000.