How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?
CREATE FUNCTION getratews11 (
country1 VARCHAR(100),
country2 VARCHAR(100) )
RETURNS DOUBLE
LANGUAGE SQL
CONTAINS SQL
EXTERNAL ACTION NOT DETERMINISTIC
BEGIN
…
END
A. CALL getratews11(‘USA’,’CANADA’)
B. CALL expenses.getratews11(‘USA’,’CANADA’)
C. SELECT getratews11(‘USA’,’CANADA’) FROM expenses
D. SELECT * FROM TABLE(getratews11(‘USA’,’CANADA’)) AS convert_currency