MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » March 2008

RE: How to Combine two files



fixed

What do you mean by "resolve"?

If the file structures are identical, CPYF should merge the data,
exclusive of unique key constraints. Don't do this on your production
files unless you're absolutely certain; otherwise create a third file to
hold the merged data.

Using an SQL UNION would pull the data from both tables.

Query/400 wants to join the files together so that is problematic.

Using RPG matching records (MR) logic could also get you there if some
(key) fields match.

NOTE: None of these suggests the data would "make sense" in a
transactional way.


Loyd Goodbar
Senior programmer/analyst
BorgWarner
TS Water Valley
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Srinivas Boggula
Sent: Wednesday, March 12, 2008 10:45
To: Midrange Systems Technical Discussion
Subject: How to Combine two files

Hi All,

I have two objects exits in two different libraries with same file name
with different data I want to merge both files data to one report

Example : Library A and Library B

Filename : File1 in both libraries with different data


I tried to combine both files data but couldn't able to resolve.

Can any please explain how to do it.

Thanks in advance

Regards,
Srinivas


iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and Ranked No.6
by Business Today-Mercer Human Resource Consulting-TNS in a cross
industry survey of Best Companies to work for in India
----------------------------------------------------------------DISCLAIM
ER---------------------------------------------------------
Information transmitted by this EMAIL is proprietary to iGATE Group of
Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is
privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL
immediately notify the sender at iGATE or mailadmin@xxxxxxxxx
and delete this EMAIL including any attachments






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact