MINIMUM DIVIDE SCALE field (DECDIV3 subsystem parameter)
The DECDIV3 subsystem parameter determines whether to retain at least three digits to the right of the decimal point after any decimal division.
| Acceptable values: | YES, NO |
|---|---|
| Default: | NO |
| Update: | option 28 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM DECDIV3 |
Certain accounting applications might need this option.
- YES
- Retains at least three digits to the right of the decimal point after any decimal division.
- NO
- Does not retain three digits to the right of the decimal point after decimal division. Use NO, the default, to accept the usual rules for decimal division in SQL.