Numeric Data Type

The following are the rules for table column values of numeric data type:

Must contain at least one numeric digit.
Total trimmed length of the input must not exceed the maximum length of the input plus one each for decimal point and sign if either or both is typed.

The following table lists the types of valid numeric inputs and their valid positions:

Valid Characters	Valid Positions
space	Trailing, not leading or embedded.
'-', '+'	First character (DB2 does not allow trailing sign).
0-9	If leading sign, second to last character. If no sign, first to last character.
'.'	Invalid if no decimal places. Optional if decimal places, but only 1 allowed. From last character - decimal places to last character.

Note: For more information about string representations of numeric values, see the DB2 documentation.