Re: CPYF

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

that is a good idea.

On Wed, Sep 24, 2014 at 3:50 PM, Monnier, Gary <Gary.Monnier@xxxxxxxxx>
wrote:

> 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.