RE: How to Combine two files

["Craig Jacobsen" <CraigJacobsen@xxxxxxxxxxx>]

Srinivas,

I do understand you probably do not speak or write English that well.

You need to learn proper "netiquette".

Here are two hints (if you are trying to use an RPG program to work with the
same files:

CLP to override the files prior to your call (OVRDBF)
ExtFile in your RPG program.

If you are using SQLRPGLE you need to hardcode the library.

Note:  you will have to override one of your files and use rename in your
RPG prior to compiling.

HTH,

Craig

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
lgoodbar@xxxxxxxxxxxxxx
Sent: Wednesday, March 12, 2008 12:34 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: How to Combine two files 

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