Hi, I want to create a UDF from a Java class which can be used in a SQL statement. For eg: I have an Employee table in DB2 and Oracle. Columns: EMP_ID, FRST_NM, LST_NM, DEPT_ID I have a Java calss which concatenates FRST_NM and LST_NM. package com.udf public class Concat { public String concat(String in1, String in2) { return in1 + " " + in2; } } I need to be able to call this concat in any SQL: Select EMP_ID, concat(FRST_NM, LST_NM) from Employee; -- DB2 Select EMP_ID, concat(FRST_NM, LST_NM) from Employee; -- Oracle Is this possible? If yes how would i create a UDF "Concat" from this java class? Thanks in Advance!!! Regards, Prashant.
... View more