Arbitrary Numeric

You can set the Arbitrary Numeric property of the SQL Engine to control how to parse SQL text when the query has a “DECIMAL” or “NUMERIC” datatype. This property can be changed by choosing Administration -> Configuration -> Server -> SQL Engine -> SQL Language -> Arbitrary Numeric/Arbitrary Decimal

By setting this to TRUE, DECIMAL/NUMERIC declaration without specifying precision and scale will result in an arbitrary numeric value.

This option can also be set for specific datasources that support the Numeric datatype. For example, to change the Oracle specific arbitrary behavior option, select Administration -> Configuration -> Data Sources -> Oracle Sources -> Arbitrary Numeric. The default value for the datasource specific property is TRUE. The datasources which has this option are Oracle, Postgres, Greenplum and Teradata.

Data Type

Boolean

Default

False