DEC bind option

The DEC bind option specifies the maximum precision to be used in decimal arithmetic operations. If a value is not specified, Db2 uses the value specified in the DECIMAL ARITHMETIC field on panel DSNTIP4.

Command option Option values Used with
DEC
  • ( 15 )
  • ( 31 )

Option values for DEC

DEC(15)
Use the 15-digit precision in decimal arithmetic operations.
DEC(31)
Use the 31-digit precision in decimal arithmetic operations.

Default values for DEC

Process Default value
BIND SERVICE The value specified in the DECIMAL ARITHMETIC field of the DSNTIP4 subsystem parameter