You cannot define precision and scale when declaring a DECIMAL, because they are assigned automatically. It is only possible to specify precision and scale when casting to a DECIMAL.
SQL literals that consist of an unquoted string of digits only, that is, that contain neither a decimal point nor an exponent (for example 12345) are of type INTEGER if they are small enough to be represented as integers. Otherwise they are of type DECIMAL.
SQL literals that consist of an unquoted string of digits, optionally a decimal point, and an exponent (for example 123e1), are of type FLOAT if they are small enough to be represented as floats. Otherwise they are of type DECIMAL.
SQL literals that consist of the keyword DECIMAL and a quoted string of digits, with or without a decimal point and with or without an exponent, are of type DECIMAL, for example, DECIMAL '42', DECIMAL '1.2346789e+203'.
Related concepts
Message flows
ESQL data types
Mappings
Related tasks
Developing message flow applications
Developing ESQL
Related reference
Built-in nodes
ESQL INTEGER data type
ESQL FLOAT data type
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak17820_ |