If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Announcement
Collapse
No announcement yet.
how do I combine two physical files or two logical files?
Re: how do I combine two physical files or two logical files?
CPYF MBROPT(*ADD) would work, read the 2 frigging files, create a join logical or multi-format logical, etc. (too many variables) what is the end goal? we need more (and better) information.
I'm not anti-social, I just don't like people -Tommy Holden
Kit http://www.ecofitonline.com
DeskfIT - ChangefIT - XrefIT
___________________________________
There are only 3 kinds of people -
Those that can count and those that can't.
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
N.b.
You can't do the FULL JOIN on the AS400.
Instead you have to do a left join and union it with a right exception join. It is effectively the same thing but the SQL becomes much more complicated. There is a brief explanation of this here:
Comment