Hi,
I would like to pass an argument to my java method such as a String
to point to a specific resultset to return.
By example, my method is :
public static ResultSet read(String resultSetIDToReturn){ ...}
how do i have to change this example to make it works ? :
CREATE FUNCTION externalEmployees
()
RETURNS TABLE
(
employeeId INT,
lastName VARCHAR( 50 ),
firstName VARCHAR( 50 ),
birthday DATE
)
LANGUAGE JAVA
PARAMETER STYLE DERBY_JDBC_RESULT_SET
NO SQL
EXTERNAL NAME 'com.acme.hrSchema.EmployeeTable.read'
Any help would be very appreciate,
Nico
