RE: UDF Syntax

OOPS...

ENF IF should be END IF :)

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of ibm
Sent: Wednesday, February 17, 2010 1:13 PM
To: Midrange Systems Technical Discussion
Subject: UDF Syntax

What is wrong with the syntax of my UDF? The compiler throws on the SET
RESULT and SET RECCOUNT lines as well as on the IF statement. Do I need
to set up a cursor?

Thanks
chris


BEGIN
DECLARE RESULT DECIMAL ( 13 , 2 ) ;
DECLARE RECCOUNT INTEGER ;

SET RESULT = 0;
SET RECCOUNT = 0;

SELECT COUNT(*) INTO RECCOUNT FROM IWPREPORTS.BOOK07R_HELPER1 WHERE
ITCLS = PARAM_ITCLS;

IF RECCOUNT = 1 THEN
SELECT YTD INTO RESULT FROM IWPREPORTS.BOOK07R_HELPER1 WHERE
ITCLS = PARAM_ITCLS;
ELSEIF RECCOUNT = 0 THEN
SELECT
SUM(AMFLIB.MTHACTVY.INSAH) INTO RESULT
FROM
AMFLIB.MTHACTVY
WHERE
AMFLIB.MTHACTVY.ITCLS = PARAM_ITCLS AND
AMFLIB.MTHACTVY.TDATE BETWEEN PARAM_STARTDATE AND PARAM_ENDDATE
AND
( ( AMFLIB . MTHACTVY . SACUR >= 10 AND AMFLIB . MTHACTVY
. TDATE < PARAM_YEARSTART ) OR
( AMFLIB . MTHACTVY . SACUR < 10 AND AMFLIB . MTHACTVY .
TDATE >= PARAM_YEARSTART ) );
-- UPDATE TEMPORARY TABLE
INSERT INTO IWPREPORTS.BOOK07R_HELPER1 (ITCLS,YTD) VALUES
(PARAM_ITCLS,RESULT);
ENF IF;



RETURN RESULT ;
END