SET CURRENT DECFLOAT ROUNDING MODE

The SET CURRENT DECFLOAT ROUNDING MODE statement changes the value of the CURRENT DECFLOAT ROUNDING MODE special register.

Examples:

Set the CURRENT DECFLOAT ROUNDING MODE special register to ROUND_UP using a string constant and using a keyword.

  SET CURRENT DECFLOAT ROUNDING MODE = 'ROUND_DOWN'

For more information, see SET CURRENT DECFLOAT ROUNDING MODE in the SQL Reference topic in the Information CenterLink to Information center.