× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.