Retrieve from the stock control table (CONTROL) the rows for which the product of the unit price (PRICE) and the quantity (QUANTITY) is greater than 15,000,000:
SELECT PCODE, PRICE, QUANTITY
FROM CONTROL
WHERE PRICE * QUANTITY > 15000000
If the overflow error suppression feature is not in effect, overflow occurs in the product of the unit price and the quantity (PRICE * QUANTITY) for the row with B-300 as the product code (PCODE). Processing is cancelled when the overflow occurs.
Even with the overflow error suppression feature in effect, overflow occurs for the row with B-300 as the product code (PCODE), but processing continues.
The result of an operation in which overflow occurs is the null value. Because the null value does not satisfy the search condition, the row that contains the null value is not retrieved.