User defined scalar function returns zero rows
I have created the following simple function.
CREATE FUNCTION FUNCTION_MUL(IN_VAR INT)
RETURNS RESULT INT LANGUAGE SQLSCRIPT
RESULT := :IN_VAR * :IN_VAR;
I call this function as SELECT FUNCTION_MUL(2) as RESULT FROM DUMMY;
I always get zero errors returned.
Kindly help me in resolving it.
Thanks & Regards,