I am a newbie and really needs some assistance. I have struggled with this code. Any assistantance will be very appreciated. The code is below....

CREATE FUNCTION increment_seria l_1 (p_serial_num VARCHAR(4000) )
RETURNS VARCHAR(4000)
LANGUAGE SQL

BEGIN ATOMIC

DECLARE l_pattern VARCHAR(30) DEFAULT '[A-Z]';

--| l_components OWA_TEXT.VC_ARR ;

--* [200042]"C:\MTK\project s\Unknown1\incr ementnm.src"(29 :16)-(29:30)Unrecogn ized...

Can someone help me convert this from Oracle PL/SQL to DB2 PL UDF? If I can see this example maybe will help me with the others. Thanks in advance.

CREATE OR REPLACE FUNCTION "GETCRITERIALIS T" (
I_child_care_ra te_id IN CHILD_CARE_RATE .ID%TYPE )
RETURN VARCHAR2 IS

CURSOR C_spec_crit_cod e IS
SELECT (DECODE(ROWNUM, 1, '', ', ') || cd.short_decode _name) short_decode_na me...