1.1.1

System.DecimalEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.DecimalADO.NET metadata type
DecimalADO.NET mapped System.Data.Dbtype
DbDataReader.GetDecimalADO.NET getter
Syntax in CREATE TABLE
{ DECIMAL | DEC } [(precision [, scale ])]
Example
-- this cast loses fractional precision
values cast (23.8372 AS decimal(4,1));
-–- results in:
23.8
-- this cast is outside the range
values cast (97824 AS decimal(4,1));
–-- throws exception:
ERROR 22003: The resulting value is outside the range for the data type
DECIMAL/NUMERIC(4,1).
DOUBLE
Provides 8-byte storage for numbers using IEEE floating-point notation.
Arithmetic operations do not round their resulting values to zero. If the values are too small, you will receive an
exception. Numeric floating point constants are limited to a length of 30 characters.
For behavior with other types in expressions, see Numeric type promotion in expressions, and Storing values of
one numeric data type in columns of another numeric data type.
java.lang.DoubleEquivalent Java type
Note: The maximum/minimum limits are different from
those of java.lang.Double as noted below.
-1.79769E+30Minimum value
1.79769E+308Maximum value
2.225E-307Smallest positive value
-2.225E-307Largest negative value
5Default precision
0Default scale
java.sql.Types.DOUBLEJDBC metadata type
ResultSet.getDouble, PreparedStatement.setDoubleJDBC methods
System.DoubleEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.DoubleADO.NET metadata type
DoubleADO.NET mapped System.Data.Dbtype
DbDataReader.GetDoubleADO.NET getter
vFabric SQLFire User's Guide628
vFabric SQLFire Reference