Define a table function that returns the employees in a specified department number.
CREATE FUNCTION DEPTEMPLOYEES (DEPTNO CHAR(3)) RETURNS TABLE (EMPNO CHAR(6), LASTNAME VARCHAR(15), FIRSTNAME VARCHAR(12)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC DISALLOW PARALLEL RETURN SELECT EMPNO,LASTNAME,FIRSTNME FROM EMPLOYEE WHERE EMPLOYEE.WORKDEPT =DEPTEMPLOYEES.DEPTNO
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.