testadd.sql

DROP FUNCTION TESTADD@

CREATE FUNCTION TESTADD( A INTEGER,

                         B INTEGER )

RETURNS INTEGER

NO EXTERNAL ACTION

------------------------------------------------------------------------

-- SQL UDF (Scalar)

--  A 

--  B 

------------------------------------------------------------------------

F1: BEGIN ATOMIC

RETURN A+B;

END@

select TESTADD(10, 20) from sysibm.sysdummy1@