UDTF with SQL and JDBC call

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Hi all,

I have a working sqlrpgle UDTF that returns a table and works very well
from another SQLRPGLE within a declare cursor-fetch logic.  

I have couple of problems though.  I cannot get this to work
interactively with "select * from table(a())x" command.  I think, for
the same reason, I cannot get this to work from servlet as well.  I get
java.sql.SQLexception error at 
        CallableStatement stmt = con.prepareCall(SQLcall);
I am using      "com.ibm.as400.access.AS400JDBCDriver" with
"jdbc:as400://" connection.

My udtf declaration looks something like:

Create Function fn
       ( Iparm  char(1),..)      
  Returns Table               
       ( rfield  char(10),..)     

  Language RPGLE              
  No SQL                      
  scratchpad                  
  final call                  
  not deterministic           
  Parameter Style DB2SQL      
  External Name fn 

Can you please tell me where I am going wrong?

Thanks for all the help,
Sudha

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