Hello,
I tried in the function:

  EXECUTE IMMEDIATE 'CREATE FUNCTION "FUNC_OSTERN" (IN "JAHR" SMALLINT)
RETURNS DATE
BEGIN

Declare a smallint;


set a    = MOD(jahr,19);  

I get the error: The function MOD does not exists...

Is it not possible to use this?

TIA
Dieter Nagy

Dieter,

It's an operator, not a function:

  SET a = Jahr MOD 19 ;

--
Fernando Dias
[Team Elevate]

Fernando,

thanks for the answer.

Dieter Nagy






Fernando Dias wrote:

Dieter,

It's an operator, not a function:

  SET a = Jahr MOD 19 ;

--
Fernando Dias
[Team Elevate]