Hello,
in a PROC I tried this:

EXECUTE IMMEDIATE 'UPDATE KALENDER set
                    isWeekday =
                    Case
                    When extract(DAYOFWEEK FROM dt) =1
                    then 0
                    else 1
                    end case';

I got the error : Expected end of expression but instead found case.

What do I wrong?

TIA
Dieter Nagy

Hello,

I found the error.

Sorry about that

Dieter Nagy












Dieter Nagy wrote:

Hello,
in a PROC I tried this:

EXECUTE IMMEDIATE 'UPDATE KALENDER set
                    isWeekday =
                    Case
                    When extract(DAYOFWEEK FROM dt) =1
                    then 0
                    else 1
                    end case';

I got the error : Expected end of expression but instead found case.

What do I wrong?

TIA
Dieter Nagy