Re: Problem with a java SQL UDF

David,
I have also never done this, but I do think you might need a return type.

Here is a quote from the DB2 docs about Java routines. It might also have to
be a static method.
return-type The data type of the value to be returned by the scalar routine.
Inside the routine, the return value is passed back to the invoker through a
return statement.
Here is the link I got the information from, maybe it will help a bit?
http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/c0009196.htm

--
James R. Perkins


On Fri, Apr 3, 2009 at 07:34, David Gibbs <david@xxxxxxxxxxxx> wrote:

Brian Johnson wrote:

o create function says method returns int but method returns nothing
o create function says method takes two parameters but method takes three

As I understand it (and I'm by no means an expert), the 'return' value is
set using the set method and the 3rd parameter is unique to the db2general
calling convention.

david

--
IBM i on Power - For when you can't afford to be out of business
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.