Sqlscript: How can to check for nan?

[markus_kohler3]

Hello community,

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 .

[314]: numeric overflow: the value -nan cannot be acceptable

The source code to reproduce the error is attached!

Thanks

Markus

PAL_error.txt.zip

[former_member4938]

I am also facing the Same Error, if any one knows the solution please share here

Regards,

HarikrishnanS

[markus_kohler3]

In my coding example the NaN was created by a bug in the used PAL procedure; the bug was fixed with PAL Rev 102.03 as well as SPS11.

Regards

Markus