dynamic SQL within a Routine
Hi,
is it possible to create a dynamic statement in a function like this:
CREATE FUNCTION find ( db char(30), where_clause varchar )
RETURNING SET(INTEGER NOT NULL)
DEFINE foundVar SET (INTEGER NOT NULL);
DEFINE tab_db CHAR(30);
DEFINE pred VARCHAR;
SELECT oid INTO foundVar
FROM tab_db = db
WHERE pred = where_clause;
RETURN foundVar;
END FUNCTION;
Does anybody know how I can create a dynamic statement within a routine?
Thanks for your advice.
peter