|
I've managed to get an ILE RPG program with embedded SQL to return a result set, and if I call that program from Net.Data, I can get the result set into a Net.Data table variable. Works very nicely, and will hopefully get us away from so much Net.Data coding. But we're trying to get away from RPG programs and toward writing RPG subprocedures that are called by CLLE programs. Is it possible to turn my RPG program into a subprocedure and call it from a CLLE in such a way that it will receive the returned result set and pass it back to my Net.Data macro? I've tried this, and I'm getting an error saying that there are no result sets available from my CLLE program (sqlstate 01646, sqlcode 7050). Thanks! Mike E.
As an Amazon Associate we earn from qualifying purchases.
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.