You can specify one of the following datatype categories:
-
BOOLEAN: returns a true or false indicator.
-
CHAR or CHARACTER: use for character and varchar strings. No length needs to be specified. Internally, a Java String is generated.
-
DEC or DECIMAL: use for fixed point numbers, numbers with precision and scale (although it can be specified with just precision). Internally, a Java BigDecimal is generated.
-
DOUBLE: use for all float, double, or real datatypes. Internally, a Java double is generated.
-
INT or INTEGER: use for all integer types (smallint, int, and long). Internally, a Java long is generated.
Note: Dates, times, and timestamps are handled as strings and are not supported as explicit types. For transformation required for these types, you can use the Date format predefined methods.