Given the following function:
CREATE FUNCTION emplist ()
RETURNS TABLE ( id CHAR(6)
, firstname VARCHAR(12)
, lastname VARCHAR(15) )
LANGUAGE SQL
BEGIN ATOMIC
RETURN
SELECT EMPNO, FIRSTNME, LASTNAME
FROM EMPLOYEE
WHERE WORKDEPT IN (‘A00’, ‘B00’);
END
How can this function be used in an SQL statement?
A.
SELECTTABLE(EMPLIST()) FROM EMPLOYEE
B.
SELECTTABLE(EMPLIST()) AS t FROM EMPLOYEE
C.
SELECTEMPLIST(id, firstname, lastname) FROM EMPLOYEE
D.
SELECT id,firstname, lastname FROM TABLE(EMPLIST()) AS t