CREATE FUNCTION stu ( dno char(4))
RETURNS TABLE (
sname char (10) ,
sex char (4),
)
LANGUAGE SQL
READS SQL DATA
NO EXTERNAL ACTION
DETERMINISTIC
RETURN
SELECT sname,sex
FROM student
WHERE student.dno = stu.dno;
db2 SELECT * FROM TABLE(stu('4')) AS 4