× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.