The next table lists the simple numeric types. All but NUMBER are value types.
Type | Limits | Comments |
---|---|---|
BIGINT | Values range from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807; no decimal places. |
BIGINT is equivalent to BIN(18) without decimal places. |
BIN(n) | Specify 4, 9, or 18 digits; however, the number of digits in a value can be one higher, as demonstrated by the ranges for BIGINT, INT, and SMALLINT. |
Not implemented in Eclipse IDE for EGL Web Developers. n is the number of positive digits, including decimal places.The internal format is numeric binary. |
DECIMAL(n), DECIMAL(n, p) |
32 digits. | n is the number of positive digits, p is
the number of decimal places. The internal format is packed decimal. |
FLOAT | In Java output, positive values range from 4.9e-324 to 1.7976931348623157e308. | FLOAT is the basis of a 64-bit double-precision floating-point value. |
INT | Values range from -2,147,483,648 to 2,147,483,647; no decimal places. |
INT is equivalent to BIN(9) without decimal places. |
MONEY, MONEY(n), MONEY(n, p) |
32 digits. | Not implemented in Eclipse IDE for EGL Developers. MONEY is equivalent to DECIMAL, but has 2 decimal places and a currency symbol by default. |
NUM, NUM(n), NUM(n, p) |
31 digits. |
Not implemented in Eclipse IDE for EGL Web Developers. The value is zoned decimal, for use with mainframe data.Each byte in the value is a character that represents a digit. The sign is represented by a sign-specific hexadecimal value in the left half of the rightmost byte: EBCDIC F for positive, D for negative. |
NUMBER | This reference type is available only as a function parameter outside of a library or service. | |
NUMC(n) | 18 digits. |
Not implemented in Eclipse IDE for EGL Web Developers. The value is zoned decimal, for use with mainframe data.Each byte is a numeric character that represents a digit. The sign is represented by a sign-specific hexadecimal value in the left half of the rightmost byte: EBCDIC C for positive, D for negative. |
PACF(n) | 18 digits. |
Not implemented in Eclipse IDE for EGL Web Developers. The value is packed decimal, for use with mainframe data.The sign is represented in the rightmost byte: EBCDIC F for positive, D for negative. |
SMALLFLOAT | In Java output, positive values range from 1.40239846e-45 to 3.40282347e+38. | SMALLFLOAT is the basis of a 32-bit single-precision floating-point value. |
SMALLINT | Values range from -32,768 to +32,767; no decimal places. |
INT is equivalent to BIN(4) without decimal places. |
Platform | Issue |
---|---|
JavaScript generation | BIN is supported only if the type has no decimal places. |