Easytrieve comparing



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Easytrieve comparing

Postby sameeha_basha » Tue Nov 15, 2011 12:26 pm

Hi,

I am facing problem while comparing two files.

Myinput file:(filea)

UPN someotherfields
123457
345678
345678
345678
987654

fileb

UPN amount
123457 5678.00
234567 0001.00
345678 3421.00
987654 4573.00


the expected output will be:

UPN
123457 5678.00
345678 3421.00
345678 3421.00
345678 3421.00
987654 4573.00


i have used if matched statement. But the duplicate records in my input file is not written in my output file.

Is there any way to include all the duplicate records in my input file and write it in my output file?

Please anyone help me to resolve this ASAP?
sameeha_basha
 
Posts: 1
Joined: Tue Nov 15, 2011 12:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Easytrieve comparing

Postby enrico-sorichetti » Tue Nov 15, 2011 12:34 pm

Please anyone help me to resolve this ASAP?

unfortunately nobody here does ASAP !
we answer on our own time and free of charge
if You have urgency issues the best thing to do is to hire a paid consultant who,
for the proper fee, will be happy to provide the services You need based on Your time constraints :evil:
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2966
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 160 times

Re: Easytrieve comparing

Postby BillyBoyo » Tue Nov 15, 2011 1:07 pm

sameeha_basha wrote:[...]

Is there any way to include all the duplicate records in my input file and write it in my output file?

[...]


Yes. You have to have the correct logic in your program.

Please post your JOB statement and all the IF statements which relate to the file matching.

There is no way of doing this any faster than it just happens to go, except by you not waiting for us but concentrating on what the manual says.

You can combine the two approaches.

Are you using statements which deal with duplicates?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Easytrieve comparing

Postby dick scherrer » Tue Nov 15, 2011 11:08 pm

Hello and welcome to the forum.

For someone to help, you need to post your "match" code whether this is an IF MATCHED or some of your own code.

You probably want to read about IF DUPLICATE in the documentation.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6269
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post