Existing Sales Table
The table is named orders1, and contains an infinite value in the column Sales.
| StoreID | SEQ | Sales |
|---|---|---|
| 101 | 1 | 2.01000000000000E 002 |
| 101 | 2 | ********************** |
| 101 | 3 | 2.03000000000000E 002 |
Example: TD_ISINF Call to Determine If There is an Infinite Values
SELECT StoreID, SEQ, TD_ISINF(sales) AS Infinity_value_in_Sales FROM orders1;
TD_ISINF Output to Determine If There are Infinite Values
StoreID SEQ Infinity_value_in_Sales ------------------------ 101 1 0 101 2 1 101 3 0
Example: TD_ISINF Call to Determine Count of Infinite Values
SELECT COUNT(*) FROM orders1 WHERE TD_ISINF(sales) = 1;
TD_ISINF Output from Count Call
Count(*) ----------- 1