DECFLOAT_ROUNDMODE


The DECFLOAT_ROUNDMODE option tells UNLOAD PLUS how to round values in any DECFLOAT fields in your output.


DECFLOAT_ROUNDMODE.png

If you do not specify a value, the utility uses the DECFLOAT round mode value from your DSNHDECP settings.

ROUND_CEILING

ROUND_CEILING rounds toward positive infinity. If the extra digits are all zero or the number is negative, the utility truncates the digits. Otherwise, the utility rounds the remaining value up (increments the rightmost digit by 1).

ROUND_DOWN

ROUND_DOWN truncates the extra digits (rounds toward 0).

ROUND_FLOOR

ROUND_FLOOR rounds toward negative infinity. If the extra digits are all zero or the number is positive, the utility truncates the digits. Otherwise, the remaining value is negative and the utility rounds up (increments the rightmost digit by 1).

ROUND_HALF_DOWN

ROUND_HALF_DOWN rounds to the nearest number as explained in the following table:


Extra digits

Utility action

.5 or less

Truncates the digits (rounds the remaining value down)

Greater than .5

Rounds the remaining value up (increments the rightmost digit by 1)

ROUND_HALF_EVEN

ROUND_HALF_EVEN rounds to the nearest number as explained in the following table:


Extra digits

Rightmost digit of the remaining value

Utility action

Greater than .5

Not applicable

Rounds the remaining value up (increments the rightmost digit by 1)

Less than .5

Not applicable

Truncates the digits (rounds the remaining value down)

Equal to .5

Odd

Rounds the remaining value up (increments the rightmost digit by 1)

Equal to .5

Even

Truncates the digits (rounds the remaining value down)

ROUND_HALF_UP

ROUND_HALF_UP rounds to the nearest number as explained in the following table:


Extra digits

Utility action

Less than .5

Truncates the digits (rounds the remaining value down)

.5 or greater

Rounds the remaining value up (increments the rightmost digit by 1)

ROUND_UP

ROUND_UP rounds away from 0. If the extra digits are all zero, the utility truncates the digits. Otherwise, the utility rounds the remaining value up (increments the rightmost digit by 1).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*