Skip to Content
avatar image
Former Member

Sqlscript: How can to check for nan?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 01, 2016 at 05:35 AM

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

    Regards,

    HarikrishnanS

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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