Figure 4: UDTF creation example

CREATE FUNCTION EmployeesDept(i_empno VARCHAR(6))
      RETURNS TABLE
      ( empno      varchar(6),
        firstname  varchar(14),
        lastname   varchar(17),
        workdept   varchar(3),
        departname varchar(38),
        location   varchar(16),
        salary     dec(9,2)
      )
LANGUAGE RPGLE
NO SQL
EXTERNAL EMPDEPUDTF
PARAMETER STYLE DB2SQL
SCRATCHPAD 10
NO FINAL CALL
DISALLOW PARALLEL
NO EXTERNAL ACTION
DETERMINISTIC
NOT FENCED
CARDINALITY 10