Try DataDirect Cloud Now
skip to main content
Mapping tab options : NUMBER
 

NUMBER

The NUMBER map option applies to Salesforce-based data stores:
*Salesforce
*ServiceMax
*Veeva CRM
*FinancialForce
In addition to the primitive data types, DataDirect Cloud also defines custom field data types. The NUMBER Data Type parameter defines how DataDirect Cloud maps fields defined as NUMBER (custom field data type). The NUMBER data type can be used to enter any number with or without a decimal place.
DataDirect Cloud type casts NUMBER data type to the SQL data type DOUBLE and stores the values as DOUBLE.
This type casting can cause problems when the precision of the NUMBER field is greater than the precision of a SQL data type DOUBLE value.
By default, DataDirect Cloud maps NUMBER values with a precision of 9 or less and scale 0 to the SQL data type INTEGER type, and also maps all other NUMBER fields to the SQL data type DOUBLE. Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example: The number 123.45 has a precision of 5 and a scale of 2.
Valid values for NUMBER Data Type are:
Table 178. Valid values for NUMBER Data Type
Value
Description
alwaysDouble
DataDirect Cloud maps NUMBER fields to the SQL data type DOUBLE.
emulateInteger
DataDirect Cloud maps NUMBER fields with a precision of 9 or less and a scale of 0 to the SQL data type INTEGER and maps all other NUMBER fields to the SQL data type DOUBLE.
The default value for NUMBER Data Type is emulateInteger.