AS400/DB2, 如何写自定义FUNCTION 返回 一个ROW（需要定义的格式）

wguxin

CREATE FUNCTION FUN_FROMPERSON (vrid integer)
     RETURNS ROW(LASTNAME ingeger, FIRSTNAME VARCHAR(10))
     LANGUAGE SQL
     CONTAINS SQL
     NO EXTERNAL ACTION
     DETERMINISTIC

     RETURN VALUES (vrid, '222')




Error: SQL0104 - Token LASTNAME was not valid. Valid tokens: <INTEGER>. (State:37000, Native Code: FFFFFF9