|
> I have a need to return a result set, that unto itself will have five (5) > imbedded result sets. What is the business goal here? To turn data into an XML document? Because retrieving heterogenous sets of data, while not the strength of SQL, is simple for RPG and DB2/400. If the idea is to retrieve a number of records from different database files and then transform the fields of those records into entries in an XML document, you can do this in RPG without breaking a sweat. However, you seem to need a "result set" in the middle of all this, for a reason that's not clear. Perhaps if you could state the entire program flow it might be easier to address the problem.
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.