Numeric data type

Official Content
This documentation is valid for:

Stores numeric values.

Syntax

Numeric (M.N)

Where:
M
Specifies the total number of digits for the figure (including the number of decimal positions, the decimal point and the sign if you need it).

N
Specifies the number of decimal places.

Example

Suppose you define an attribute (or a variable) whose data type is Numeric, with length: 9, decimal positions: 2, and no sign. This means that you can store a figure of up to 6 digits in the part corresponding to the whole number, plus 2 decimal positions (6 digits in the part corresponding to the whole number + decimal point + 2 digits for decimal positions = 9 digits). 

Definition

The Numeric data type allows you to store a numeric value in the DMBS.

The following table illustrates the properties used to define a Numeric data type:

Length
Decimals
Signed
Value range
Picture


Other related properties to Numeric Data Type:

Autonumber
Initial Value


See also

Maximum Numeric Length Model Property





Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.