Nonstop Database, HiRDB Version 9 UAP Development Guide

[Contents][Index][Back][Next]

2.8.1 Arithmetic operations on numeric data

Four types of arithmetic operations can be performed on numeric values in specified columns, and the results of such operations can be extracted.

The four types of arithmetic operations are addition, subtraction, multiplication, and division.

The following figure shows, as an example of performing arithmetic operations on numeric data, the procedure for calculating projected sales revenue from the unit prices and stock quantities of the products named SOCKS, and then retrieving the product code and calculation result for each product (in units of $1 million).

Figure 2-33 Example of numeric data operations

[Figure]