Need a not matching logic to write to output file

shakti · New User Joined: 20 Jan 2004 Posts: 42

Hi,

I have a requirement as follows.

input file 1
------------
emp-no
emp-name

input file2
------------
emp-no
emp-status
emp-state

output file
------------
emp-no
emp-name
emp-status
emp-state

Requirement
---------------

If emp-no from file1 is not equal to emp-no of file2
the following fields will be wriiten to output
emp-no from input file 1
emp-name from input file1
emp-status and emp-state from file2

both the input files are sorted based on emp-no

Please advice how to write the record as shown in output file...

Thanks in advance
shakti

Ramya A · Active User Joined: 26 Jul 2004 Posts: 104

Hi Shakti,

shakti · New User Joined: 20 Jan 2004 Posts: 42

Hi Ramya,

I would like to write the file2(Currently not matched) fields of emp-state and emp-status if emp-no of file 1 and 2 doesn't match.

Hope this will helps to understand my requirement.

Thanks and regards,
Shakti

kunalgala · New User Joined: 11 Dec 2007 Posts: 1 Location: India

Hi Shakti...
The logic as per my understanding of your requirement is as follows:
The following para is to be called in loop until either of the file end is reached.

PROCESS-PARA.
READ FILE1 AT END..
READ FILE2 AT END ...
IF FILE1 AND FILE NOT AT END.....
IF EMP-NO in FILE1-REC NOT = EMP-NO IN FILE2-REC
MOVE EMP-NO IN FILE1-REC TO EMP-NO IN OUTFILE-REC
MOVE emp-name IN file1-REC TO EMP-NAME IN OTFILE-REC
MOVE emp-status IN FILE2-REC TO emp-status IN OUTFILE-REC
MOVE emp-state IN FILE2-REC TO EMP-STATE IN OUTFIILE-REC

(Note .... implies the required logic is not entioned here)

Hope this helps...

shakti · New User Joined: 20 Jan 2004 Posts: 42

Hi,

I tried this option too. But getting invalid file reference field error...

Any easytrieve suggestion is highly appriceated.

Thanks
Shakti

Anuj Dhawan · Posted: Tue Dec 11, 2007 3:52 pm

Hi,

Your post is in CA-products forum..so I'm bit not sure whether you would like to do it using COBOL or SORT. However if COBOL, there is A "sticky" in COBOL forum that can be useful for you...here is the link..

If SORT, a JOB like this can be handy,

shakti · New User Joined: 20 Jan 2004 Posts: 42

Hi Anuj,

Thanks for ur suggestion.
But i wanted to do it using easytrive.

thanks much
Shakti

Anuj Dhawan · Posted: Wed Dec 19, 2007 10:55 pm

Hi,

I do not use easytrive so can not provide the code right away..However it should have a COBOL like pseudo code, there is a "sticky" in COBOL forum that can be useful for you as far as pseuo code is concern...here is the link..

Douglas Wilder · Posted: Thu Dec 20, 2007 2:08 am

Easytrieve is very good for file matching. "invalid file reference field error" is usually the result of using variables from one file when you have a non-match condition and you are processing a record from the other file. If you show us your matching logic including the statement the error is on we could help you find the problem.