UDF to be used in SQL from a Java Class.

Reply
New Contributor
Posts: 2

UDF to be used in SQL from a Java Class.

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.

Super User
Posts: 19,171

Re: UDF to be used in SQL from a Java Class.

The functionality (concat) you want is easily accessible in SAS. 

 

Using java class functions in SQL on the other hand I'm not sure about. Can you explain a bit more about what you're trying to do? I assume it's make the same code run on both Oracle and SAS without having to make manual changes?

New Contributor
Posts: 2

Re: UDF to be used in SQL from a Java Class.

I should have been more clear..The Concat was an example of how we want to use a Java Class.

We have a functionality that we would like to use in SAS and is not provided as a Function in SAS or Database layer.

All the logic has been written in Java and rather than having the logic recreated at each edge point(Oracle, DB2, Teradata, Hive etc)

we would like to create a UDF based on this Java Class.

 

I am aware we can call Java objects in SAS but have not come across any documentation where we can create a UDF using a Java Class(jar).

 

Thanks,

Prashant.

Ask a Question
Discussion stats
  • 2 replies
  • 242 views
  • 0 likes
  • 2 in conversation