BIRT (which uses JDBC and JT400) doesn't appear to like UDTFs. But it seems to like Stored Procedures that return a result set.

Most of the examples I've seen simply have a SELECT (without an INTO clause) in the stored procedure. But DB2/400 doesn't seem to like SELECTS without INTO clauses in stored procedures.

Then there is at least one example I've seen that uses a cursor as a parameter, but that doesn't look very promising for DB2/400, either.

Can somebody point me in the right direction here?


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 by 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.