함수를 사용해봤습니다.

1. source

>cat 1.db2 

drop function rstr
@
CREATE FUNCTION  rstr (pstr VARCHAR(50), ptc VARCHAR(1))
RETURNS  VARCHAR(50)

BEGIN ATOMIC
     DECLARE  vstr VARCHAR(50) DEFAULT  '';

     SET vstr=pstr;

     WHILE  locate(ptc,vstr) > 0 DO

       SET vstr=substr(vstr,locate(ptc,vstr)+1);

     END WHILE;

     RETURN  vstr;
END
@


2. build

> db2 -td@ -vf 1.db2 



3. test

> db2 "values rstr('1_2_33','_')"      

1                                                
--------------------------------------------------
33                                               

답변 감사합니다.

함수를 꼭 써야 할까요???