AppletTalk.com

shang-de · Guest

Hi,
I am trying to write a UDF to convert an Integer into a String.
but I got a following error:
sqlstate: 38503
sqlcode: -430
I know there must be a mistake in my udf function, but I can't find out
it. here is my code:

public class UDFsrv extends UDF
{

String curout = "0";

public void path (int inputInt,
String outString) throws Exception {

try{

set(2, curout);

curout = curout + ":" +String.valueOf(inputInt);

} catch ( Exception e ) {
throw e;
}
}
}

CREATE FUNCTION path (int)
RETURNS VARCHAR(100)
EXTERNAL NAME 'UDFsrv!path'
LANGUAGE java
PARAMETER STYLE db2general
DETERMINISTIC
FENCED
NOT NULL CALL
NO SQL
NO EXTERNAL ACTION
NO SCRATCHPAD
NO FINAL CALL
ALLOW PARALLEL
NO DBINFO

hopely someone can tell me the mistake. any help would be appreciate!
Tahnks a lot!
Shang

--
Posted via http://dbforums.com