using dynamic SQL in a function

[bondio]

I have a function that returns a table and I want to build a different SQL statement depending on the IN parameter

something like:

CREATE FUNCTION DYN_FCTN
( TBL VARCHAR(80) )
RETURNS TABLE ( COL1 INTEGER , COL2 VARCHAR(12) )

BEGIN

DECLARE QUERYSTRING VARCHAR ( 1000 ) ;

SET QUERYSTRING= 'SELECT 1 COL1, ''BLA'' COL2 from '||TBL||'WHERE COL3=3;'; ---here I want to build my statement depending on the IN param

RETURN -- I Want to return the result of the statement previously build
PREPARE SCLI FROM QUERYSTRING ;
EXECUTE SCLI ;
END ;