From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Bradley V. Stone
Sent: Thursday, March 13, 2008 2:22 PM
Subject: SQL Question - Merging files or result sets?
I've run into a situation using Dynamic SQL in an RPG program where I'd
to be able to merge data from two files prior to running an SQL statement,
or merge the results sets from separate SQL statements if that is needed.
This isn't a join, it's two files with identical layouts, but different
field names and different category of data. Otherwise the files are
When a user does a search, they can search file A, file B, or both. So
like to try to write this dynamic enough so all I do is check the search
flags they set and build my SQL appropriatly. Especially when they search
both so it will "mesh" the data from the two files in the result set.
Like I said, both files are exactly the same layout, just different field
Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives