Re: CPYF

[Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>]

they are Rob. the reason i want uniformity is for the reporting tool. it
will group on one field this way.

On Wed, Sep 24, 2014 at 3:51 PM, <rob@xxxxxxxxx> wrote:

> First of all are the number, and attributes of all columns the same (other
> than column name)?
> IOW, if
> - bytes A thru B are for order number (irregardless of what each table
> calls the column)
> - bytes B+1 thru C are for part number (irregardless of what each table
> calls the column)
> - bytes C+1 thru D are for shipped quantity (irregardless of what each
> table calls the column)
> - bytes D+1 thru E are for net dollar amount (irregardless of what each
> table calls the column)
> and so on
> then you might be able to use FMTOPT(*NOCHK).
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   09/24/2014 03:40 PM
> Subject:        CPYF
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> 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.