SET CURRENT PRECISION
The SET CURRENT PRECISION statement assigns a value to the CURRENT PRECISION special register.
Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Authorization
None required.
Syntax
>>-SET CURRENT PRECISION--=--+-string-constant-+--------------->< '-host-variable---'
Description
This statement replaces the value of the CURRENT PRECISION special register with the value of the string constant or host variable. The value must be a character string 5 bytes in length. The value must be 'DEC15,' 'DEC31,' or 'Dpp.s', where 'pp' is either 15 or 31 and 's' is a number between 1 and 9. If the form 'Dpp.s' is used, 'pp' represents the precision that will be used with the rules that are used for DEC15 or DEC31, and 's' represents the minimum divide scale to use for division operations. The separator used in the form 'Dpp.s' can be either the '.'or the ',' character, regardless of the setting of the default decimal point.
Example
EXEC SQL SET CURRENT PRECISION = 'DEC15';