Re: CPYF

Why not create an SQL View over them?

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Wednesday, September 24, 2014 12:40 PM
To: Midrange Systems Technical Discussion
Subject: CPYF

I have 2 files that I want to join and use as 1. the data is about 9
columns like

order#, part#, shipped qty, net$

in one file the fields are ouord#, the other would be odord# etc.

when i do cpyf *nochk, it does not copy the data of the second.

Would it work if i create a new table that will receive the files from
both.

I seem to be missing some thing with mapping. should i do map and nochk
does it move the data of odord# to ouord# col ( the first example) or
better to copy into a new table with diff col names?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.