SQL NULL return

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Hi All,
I have servlets accessing UDTF written in SQLRPGLE.  I encounter the
following problems that I need help with.

-       I wrote another UDF that is part of a declare/select of the UDTF
that is accessed by Java.  But I get this function not found in the
*LIBL error.  I am also not able to qualify my UDF with the library.  Is
there a solution to this?  My select statement looks like this:
        UDF func1(field2,field3) - returns calculated number
        UDTF    Select field1, func1(field2,field3),field4 from file
        The java access to udtf - Select * from table(UDTF(inp1, inp2))
x
-       I have problems with some of the packed decimal fields when they
are null.  I get 'Java Number Invalid Expression error' Should I define
my UDTF as null capable or something?  
-       Dates/Times - when the date/time is null, I have to send back a
date/time info and not a 0 or null. Now I have to write a logic in Java
to look for those values and move a 0.  Can this be avoided?

Thanks for all the help,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax