Positions 41-42 (Decimal Positions)
| Free-Form Syntax | Decimal-position parameter of the data-type keyword or parameter of the TIMESTAMP keyword |
Positions 41-42
are used to indicate the number of decimal positions in a numeric subfield
or standalone field. If the field is non-float numeric, there must always
be an entry in these positions. If there are no decimal positions enter a
zero (0) in position 42. For example, an integer or unsigned field (type I
or U in position 40) requires a zero for this entry.
- Entry
- Explanation
- Blank
- The value is not numeric (unless it is a float field) or has been defined with the LIKE keyword.
- 0-63
- Decimal positions: the number of positions to the right of the decimal in a numeric field.
This entry can only be supplied in combination with the TO/Length field. If the TO/Length field is blank, the value of this entry is defined somewhere else in the program (for example, through an externally described data base file).
The decimal positions entry can also be used to specify the number of fractional seconds for a timestamp. If the length of the timestamp is not specified, you can specify a between zero and twelve fractional seconds. If you specify zero fractional seconds, the length of the timestamp will be 19. If you specify between one and twelve fractional seconds, the length of the timestamp will be 20 plus the number of fractional seconds.