Re: SQL - 2 Result sets, 1 Cursor.

Dave

Do the 2 result sets have the same column structure?

What version/release are you on?

If the 2 sets have the same columns, then maybe

select fields1 from files1

union

with (select fields1 from files1) as alias select fileds2 from alias

This'd run the first query twice, unfortunately.

HTH

Vern

At 10:17 AM 9/27/02 -0400, you wrote:

We are trying to use the result set from one SQL Select statement as the
input to a second SQL Select statement.  In the end, we want two result
sets that we can pass back in one Cursor.  The first being the original
Select result set, the second being the result from the second SQL Select.

If anyone has a good example of an SQLRPGLE program that does something
like this, could you please post it on the list?

David Smith