DB2 AS400 Java function always returns same value

Question

Hello, I am writing a user defined function to DB2 on AS/400 in Java and the strangest thing happen..
I am always getting the same result from the function even when i am changing it, even if i am dropping it and create it again and even when i specify NOT DETERMINISTIC..
Does any one have ever encountered a behavior like that?

Answer 1

Well, Apparently this behavior only happens when i run queries from AS/400's STRSQL...
Queries outside of the AS/400 environment returns expected results.
I hope none of you will ever need to write UDF for AS/400 in Java.. :)

Answer 2

I have the same problem but I do not call an External Action, I am just doing a native function. Any solution for this bizzarre problem?