Sqlscript: How can to check for nan?
I'm executing a PAL forecast procedure (AFL) which gives a result table. Depending on the input data, the PAL forecast algorithm fails leading to -nan in the result table.
How can I check the result table for -nan? It dumps if I do a simple select:
Could not execute 'SELECT * FROM PAL_FORECASTSLR_RESULT_TBL' in 3 ms 300 µs .
: numeric overflow: the value -nan cannot be acceptable
The source code to reproduce the error is attached!