Existing Sales Table
The sales table is named orders1.
| StoreID | SEQ | Sales |
|---|---|---|
| 101 | 1 | 2.01000000000000E 002 |
| 101 | 2 | ********************** |
| 101 | 3 | 2.02000000000000E 002 |
| 101 | 4 | ********************** |
Example: TD_ISFINITE Call to Determine if Table Has Numeric Values
SELECT StoreID, SEQ, TD_ISFINITE(sales) AS Finite_in_Sales FROM orders1;
TD_ISFINTE Output to Determine If There are Numeric Values
StoreID SEQ Finite_in_Sales ------------------------ 101 1 1 101 2 0 101 3 1 101 4 0
Example: TD_ISFINITE Call to Determine Count of Numeric Values
SELECT COUNT(*) FROM orders1 WHERE TD_ISFINITE(sales) = 1;
TD_ISFINITE Output from Count Call
Count(*) ----------- 2