DB2 创建 函数 的异常 高人

DB2 创建 函数 的错误 求救高人
CREATE FUNCTION vchar( shu decimal , F_ID VARCHAR(20))
sw varchar(30) ;

BEGIN ATOMIC
  
  select  
 replace(replace(replace(replace(replace(replace(replace(replace(replace(A.DivisionLineValue, ' 000000000', ''), ' 00000000', ''), ' 0000000', ''), ' 000000', ''), ' 00000', ''),' 0000',''),' 000',''),' 00',''),' 0','')
  into sw
from (
  select ' ' || case char(shu)
  when '0999999999.00 '  
  then F_ID  
  else char(shu)  
  end as DivisionLineValue
  from sysibm.sysdummy1  
) as A
  

  RETURN l_type;

END ;

出现 104 错误 我对DB2 的语法不 熟悉 希望 高人指点 下 改成什么样 是正确的 



[解决办法]

SQL code

  CREATE FUNCTION Test (shu decimal , F_ID VARCHAR(20))     RETURNS varchar(20)     LANGUAGE SQL     CONTAINS SQL     NO EXTERNAL ACTION     DETERMINISTIC     return (     case when char(shu) = '0999999999.00' then F_ID     else         replace(replace(replace(replace(replace(replace(replace(replace(replace(' ' || char(shu), ' 000000000', ''), ' 00000000', ''), ' 0000000', ''), ' 000000', ''), ' 00000', ''),' 0000',''),' 000',''),' 00',''),' 0','')     end);