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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.