Range limits for numeric types
XQuery has range limits for numeric data types.
The following table lists the range limit and SQL equivalent for each XQuery numeric data type.
| XML type | Db2 XML range | SQL type mapping |
|---|---|---|
| xs:double | 34 digits of precision and an exponent range of 10**-6143 to 10**+6144 | DECFLOAT |
| xs:decimal | Up to 34 digits of precision, and a range of 1-10**34 to 10**34 -1 | DECIMAL |
| xs:integer | -9223372036854775808 to 9223372036854775807 | BIGINT |