I am getting below error with right arguments

"No authorized routine named "SRCHYRORMNTH" of type "FUNCTION" having compatible arguments was found"

The invoking statemnet looks like

SELECT name,,,, from tablename
WHERE ABS.SRCHYRORMNTH('Y','L',1324485520) = 2010


The function looks like

CREATE FUNCTION "ABS"."SRCHYRORMNTH" (v_Type CHAR(1),
v_DateType CHAR(1),
v_LONGVAL INTEGER )
RETURNS INTEGER
LANGUAGE SQL

BEGIN ATOMIC

DECLARE v_DAYOFLONGVAL INTEGER;

DECLARE v_YearMonth INTEGER;

// function logic

RETURN v_YearMonth;

END

Please let me know if i am missing something.

Any help would be appreciated!!
Jash

While you are calling the function in the select statement, explicitly typecast the data.

SELECT name,,,, from tablename
WHERE ABS.SRCHYRORMNTH(char('Y'),char('L'),int(132448552 0)) = 2010

Hi,

Thank you for the reply!!

I did found and tried the casting in another way as below

SELECT name,,,, from tablename
WHERE ABS.SRCHYRORMNTH(CAST('Y') as CHAR, CAST('L') as CHAR,CAST(1324485520) as INT) = 2010

Thanks again for your reply and time!!
jash