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
D.
SELECT id,firstname, lastname FROM TABLE(EMPLIST()) AS t
0
0
CREATE FUNCTION F1( )
RETURNS TABLE
AS
RETURN
(SELECT ProductID, ProductName, RetailPrice, Category
FROM CurrentProducts);
SELECT * FROM F1();
0
0