Re: CPYF

so just to confirm. i have 2 files.

File A.
Aord# 6
Aamt 12 2

I have one record in File A.
'12345' '100.00'

File B.
Bord# 6
Bamt 12 2

I have one record in File B.

'54321' '200.00'

If i CPYF File A to File B (add)

in B I will have, (order not important) ?

54321' '200.00'
12345' '100.00'




On Wed, Sep 24, 2014 at 4:11 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

yes it works, i will change to a view. i am just doing proof of concept
now.

On Wed, Sep 24, 2014 at 3:53 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

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.

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