db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Derby-style table function with java argument
Date Sun, 27 Apr 2008 14:28:38 GMT
> I would like to pass an argument to my java method such as a String to 
> point to a specific resultset to return.
> 
> public static ResultSet read(String resultSetIDToReturn){ ...}
> 
> how do i have to change this example to make it works ? :
> 
> CREATE FUNCTION externalEmployees
> ()
> RETURNS TABLE
...

Do you mean, how do you declare the argument to your function? You
declare it inside those parentheses:

   CREATE FUNCTION externalEmployees
   (resultSetIDToReturn varchar(128))
   RETURNS TABLE

thanks,

bryan



Mime
View raw message