Hello, I am relatively new to DB2 and i would appreciate if anybody
can give me advice on UDF table.
My question is :
1) Is performance an issue when using UDF table?
2) I read from previous post that SQL UDF work great when you can
reduce them to only RETURN. But if I have a function as followed will
i have performance issues? :
CREATE FUNCTION FUNC_TO_TBL(VAL1 VARCHAR(128), VAL2 BIGINT, VAL3
CHAR(23))
RETURNS TABLE( TEST1 VARCHAR(128), TEST1 VARCHAR(128))
NO EXTERNAL ACTION
F1: BEGIN
DECLARE VARCHAR(128) FIELD1;
DECLARE VARCHAR(128) FIELD1;
// sql query + business logic to set value to Field1
SET FIELD1 = ....
// sql query + business logic to set value to Field2
SET FIELD2 = ....
RETURN VALUES(FIELD1 , FIELD2 );
END
3) How do I optimize the UDF table?
Any advice would be much appreciated!