The result data type for binary arithmetic operations involving DECIMAL operands is as follows:

When the operand on the left is … | And the operand on the right is … | And the operator is … | Then the result data type is … |
---|---|---|---|

DATE | DECIMAL(k,j) | * / MOD | DECIMAL(p,j) These operations on DATE do not report an error, but results are generally not meaningful. |

BYTEINT SMALLINT INTEGER BIGINT |
* / + - MOD | DECIMAL(p,j) | |

DECIMAL(m,n) | BYTEINT SMALLINT INTEGER BIGINT |
+ - * | DECIMAL(p,n) |

DATE | * | DECIMAL(p,n) These operations on DATE do not report an error, but results are generally not meaningful. |

In these cases the value of p, the number of digits in the decimal result, depends on:

- The value specified for MaxDecimal in DBSControl.
For more information on DBSControl and MaxDecimal, see “DBS Control utility” in Teradata Vantage™ - Database Utilities , B035-1102 .

- The number of digits in the decimal operand, where the number of digits is k for a DECIMAL(k,j) operand on the right side of the operator or m for a DECIMAL(m,n) operand on the left side of the operator.

IF MaxDecimal is … | AND the number of digits in the decimal operand is … | THEN p is … |
---|---|---|

0 or 15 | ≤ 15 | 15 |

> 15 and ≤18 | 18 | |

> 18 | 38 | |

18 | ≤ 18 | 18 |

> 18 | 38 | |

38 | any value | 38 |

When the operand on the left is … | And the operand on the right is … | And the operator is … | Then the result data type is … |
---|---|---|---|

DECIMAL(m,n) | DECIMAL(k,j) | + - | DECIMAL(min(p, (1+max(n,j)+max(m -n,k -j))),max(n,j)) |

* | DECIMAL(min(p,m +k),(n +j)) | ||

/ MOD | DECIMAL(p,max(n,j)) |

In these cases, the value of p in the definition of the decimal result data type depends on the value specified for MaxDecimal in DBSControl and the number of digits in the DECIMAL(m,n) and DECIMAL(k,j) operands.

IF MaxDecimal is … | AND … | THEN p is … |
---|---|---|

0 or 15 | m and k ≤ 15 | 15 |

(m or k > 15) and (m and k ≤18) | 18 | |

m or k > 18 | 38 | |

18 | m and k ≤ 18 | 18 |

m or k > 18 | 38 | |

38 | m and k = any value | 38 |